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

Kolmail 1 Posts Tuesday January 20, 2009Registration date January 21, 2009 Last seen - 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 1705 users this month

rine012 6 Posts Wednesday December 17, 2008Registration date May 8, 2009 Last seen - 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 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - 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 1 Posts Monday September 15, 2014Registration date September 15, 2014 Last seen - 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/