How to connect vb6.0 to ms access 2003

Solved/Closed
Kolmail
Posts
1
Registration date
Tuesday January 20, 2009
Status
Member
Last seen
January 21, 2009
- Jan 21, 2009 at 11:54 AM
 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.

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
94
appalaswamy yadav
Apr 18, 2010 at 02:00 AM
good
0
now I am clear , thanks
0
ok
0
workable?
0
Great, thank you.
0
rine012
Posts
6
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
May 8, 2009
12
Jan 22, 2009 at 06:13 AM
hi,
try this link for more help:
http://www.eggheadcafe.com/forumarchives/VisualBasicwinapi/Feb2006/post26076141.asp
12
give the stepwise procedure about the connectivity of vb 6.0 with ms-access 2003 with any example
5
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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 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
0
Zac1122
Posts
1
Registration date
Monday September 15, 2014
Status
Member
Last seen
September 15, 2014

Sep 15, 2014 at 03:28 AM
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 : https://gexton.com/website-designing
0