How to connect vb6.0 to ms access 2003 [Solved/Closed]
Kolmail
- Jul 31, 2015 at 04:30 PM
- Posts
- 1
- Registration date
- Tuesday January 20, 2009
- Last seen
- January 21, 2009
- HOW TO do access DATADASE CONNECTION IN VB6.0
- How to connect VB 6.0 to MS Access 2003 - How-To - Programming
- Coding to link Visual basic to MS Access - How-To - Visual Basic
- Connection of vb6.0 with access 2003 - Forum - Programming
- Visual basic 6.0 projects with ms access database free download - Download - Development
- How to connect to MS Access using DAO ✓ - Forum - Programming
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 1620 users this month
Report
good
Report
now I am clear , thanks
Report
ok
Report
workable?
Report
Great, thank you.
- Posts
- 6
- Registration date
- Wednesday December 17, 2008
- Last seen
- May 8, 2009
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
- Posts
- 4481
- Registration date
- Thursday January 28, 2010
- Status
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
- Posts
- 1
- Registration date
- Monday September 15, 2014
- 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/