Related:
- How to connect vb6 0 to ms access
- How to connect visual basic 6.0 to ms access 2007 - Best answers
- Vb6.0 - Best answers
- Database connectivity in vb 6.0 with ms access pdf - How-To - Programming
- How to connect visual basic 6.0 to ms access 2007 - How-To - Visual Basic
- Connected to internet but no access ✓ - Forum - Internet/Social Networks
- Connected to vpn but cannot access network ✓ - Forum - VPN
- Wifi connected but no internet access ✓ - Forum - WiFi
4 replies
ajit
(In the General Declaration Area)
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
(in Form's Activate Event)
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=EMP.mdb;Persist Security Info=False"
cn.Open
rs.Open "select Eid,Ename,ppfSub,Basic From EmpData Order By Eid", cn, adOpenStatic, adLockPessimistic
Text1.text=rs.Fields(0)
etc
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
(in Form's Activate Event)
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=EMP.mdb;Persist Security Info=False"
cn.Open
rs.Open "select Eid,Ename,ppfSub,Basic From EmpData Order By Eid", cn, adOpenStatic, adLockPessimistic
Text1.text=rs.Fields(0)
etc
Report
appalaswamy yadav
good
Report
bala
now I am clear , thanks
Report
hi
ok
Report
san
workable?
Report
Jeff
Great, thank you.
rine012
- Posts
- 6
- Registration date
- Wednesday December 17, 2008
- Status
- Member
- Last seen
- May 8, 2009
hi,
try this link for more help:
http://www.eggheadcafe.com/forumarchives/VisualBasicwinapi/Feb2006/post26076141.asp
try this link for more help:
http://www.eggheadcafe.com/forumarchives/VisualBasicwinapi/Feb2006/post26076141.asp
shalu
give the stepwise procedure about the connectivity of vb 6.0 with ms-access 2003 with any example
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
There is no step by step. You simply use the code to connect to the database and then use command to either update/delete or select the records. Sample code to connect to a database "EMP.mdb" was given up at https://ccm.net/forum/affich-58974-how-to-connect-vb6-0-to-ms-access-2003#2
or see the link at https://ccm.net/forum/affich-58974-how-to-connect-vb6-0-to-ms-access-2003#1
or see the link at https://ccm.net/forum/affich-58974-how-to-connect-vb6-0-to-ms-access-2003#1
Zac1122
- Posts
- 1
- Registration date
- Monday September 15, 2014
- Status
- Member
- Last seen
- September 15, 2014
Please post the code you have written in an effort to resolve the problem, and our Gextom team members would be happy to provide some guidance. More info Visit at : http://gexton.com/website-designing/
