How to connect vb6.0 to ms access 2003
Solved/Closed
Kolmail
Jeff - Jul 31, 2015 at 04:30 PM
- Posts
- 1
- Registration date
- Tuesday January 20, 2009
- Status
- Member
- Last seen
- January 21, 2009
Jeff - Jul 31, 2015 at 04:30 PM
Related:
- How to connect vb6.0 to ms access 2003
- How to connect VB 6.0 with MS Access - Guide
- Connected to internet but cannot access websites ✓ - Forum - WiFi
- Internet connected but webpages won't load ✓ - Forum - Internet/Social Networks
- Vpn connects but no remote lan access ✓ - Forum - VPN
- Connected to the internet but can't browse ✓ - Forum - Internet/Social Networks
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
Jan 22, 2009 at 06:13 AM
- Posts
- 6
- Registration date
- Wednesday December 17, 2008
- Status
- Member
- Last seen
- May 8, 2009
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
Aug 3, 2010 at 07:50 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
Sep 15, 2014 at 03:28 AM
- 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
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