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

Report
Posts
1
Registration date
Tuesday January 20, 2009
Status
Member
Last seen
January 21, 2009
-
 Jeff -
Hello,Can someone explain to me how to connect vb6.0 to ms access 2003. I know to how to connect at tall.
Thanks.

4 replies

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

A few words of thanks would be greatly appreciated. Add comment

CCM 4129 users have said thank you to us this month

Posts
6
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
May 8, 2009
12
hi,
try this link for more help:
http://www.eggheadcafe.com/forumarchives/VisualBasicwinapi/Feb2006/post26076141.asp
give the stepwise procedure about the connectivity of vb 6.0 with ms-access 2003 with any example
rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
756
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
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/