How to connect vb6.0 to ms access 2003
Solved/Closed
Kolmail
Posts
1
Registration date
Tuesday 20 January 2009
Status
Member
Last seen
21 January 2009
-
21 Jan 2009 à 11:54
Jeff - 31 Jul 2015 à 16:30
Jeff - 31 Jul 2015 à 16:30
Related:
- How to connect vb6.0 to ms access 2003
- Ms access free download - Download - Databases
- How to access bios - Guide
- How to access google usa - Guide
- How to connect jio phone to laptop - Guide
- Connect bose headphones to mac - Guide
4 responses
(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 17 December 2008
Status
Member
Last seen
8 May 2009
12
22 Jan 2009 à 06:13
22 Jan 2009 à 06:13
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
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
3 Aug 2010 à 07:50
3 Aug 2010 à 07:50
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 15 September 2014
Status
Member
Last seen
15 September 2014
15 Sep 2014 à 03:28
15 Sep 2014 à 03:28
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
18 Apr 2010 à 02:00
19 Apr 2013 à 06:09
10 Jul 2013 à 04:27
31 Aug 2014 à 14:13
31 Jul 2015 à 16:30