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
- How to connect vb6.0 to ms access 2003
- Im programming with vb6.0 and ms access 2003. » Forum - Programming
- How to connect VB 6.0 to MS Access 2003 » How-To - Programming
- Connection of vb6.0 with access 2003 » Forum - Programming
- How to connect to MS Access using DAO [Solved] (Solved) » Forum - Programming
- Coding to link Visual basic to MS Access » How-To - Visual Basic
10 replies
Best answer
(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
has helped 1878 users this month
Report
good
Report
now I am clear , thanks
Report
ok
Report
workable?
Report
Great, thank you.
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
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
or see the link at http://ccm.net/forum/affich-58974-how-to-connect-vb6-0-to-ms-access-2003#1
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/