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
Jeff - Jul 31, 2015 at 04:30 PM
Related:
- How to connect vb6.0 to ms access 2003
- Ms access download - Download - Databases
- How to connect ps4 to pc - Guide
- How to access google usa - Guide
- Phpmyadmin access denied - Guide
- Connect pc to apple tv - Guide
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
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
rine012
Posts
6
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
May 8, 2009
12
Jan 22, 2009 at 06:13 AM
Jan 22, 2009 at 06:13 AM
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
give the stepwise procedure about the connectivity of vb 6.0 with ms-access 2003 with any example
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Aug 3, 2010 at 07:50 AM
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
or see the link at https://ccm.net/forum/affich-58974-how-to-connect-vb6-0-to-ms-access-2003#1
Zac1122
Posts
1
Registration date
Monday September 15, 2014
Status
Member
Last seen
September 15, 2014
Sep 15, 2014 at 03:28 AM
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
Apr 18, 2010 at 02:00 AM
Apr 19, 2013 at 06:09 AM
Jul 10, 2013 at 04:27 AM
Aug 31, 2014 at 02:13 PM
Jul 31, 2015 at 04:30 PM