How to connect vb6.0 to ms access 2003 [Solved/Closed]

Kolmail
Posts
1
Registration date
Tuesday January 20, 2009
Last seen
January 21, 2009
- Jan 21, 2009 at 11:54 AM - Latest reply:  Jeff
- Jul 31, 2015 at 04:30 PM
Hello,Can someone explain to me how to connect vb6.0 to ms access 2003. I know to how to connect at tall.
Thanks.
See more 

10 replies

Best answer
93
Thank you
(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

Thank you, ajit 93

Something to say? Add comment

CCM has helped 1620 users this month

rine012
Posts
6
Registration date
Wednesday December 17, 2008
Last seen
May 8, 2009
- Jan 22, 2009 at 06:13 AM
5
Thank you
give the stepwise procedure about the connectivity of vb 6.0 with ms-access 2003 with any example
rizvisa1
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- Aug 3, 2010 at 07:50 AM
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 http://ccm.net/forum/affich-58974-how-to-connect-vb6-0-to-ms-access-2003#2

or see the link at http://ccm.net/forum/affich-58974-how-to-connect-vb6-0-to-ms-access-2003#1
Zac1122
Posts
1
Registration date
Monday September 15, 2014
Last seen
September 15, 2014
- Sep 15, 2014 at 03:28 AM
0
Thank you
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/