Related:
- How to connect vb6 0 to ms access
- How to connect visual basic 6.0 to ms access 2007 - Best answers
- Vb6 access - Best answers
- How to Connect VB 6.0 to MS Access 2003 - How-To - Programming
- Connected to internet but cannot access websites ✓ - Forum - WiFi
- Internet connected but webpages won't load ✓ - Forum - Internet/Social Networks
- Connected to the internet but can't browse ✓ - Forum - Internet/Social Networks
- Vpn connects but no remote lan access ✓ - Forum - VPN
4 replies
ajit
(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
Report
appalaswamy yadav
good
Report
bala
now I am clear , thanks
Report
hi
ok
Report
san
workable?
Report
Jeff
Great, thank you.
rine012
- Posts
- 6
- Registration date
- Wednesday December 17, 2008
- Status
- Member
- 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
shalu
give the stepwise procedure about the connectivity of vb 6.0 with ms-access 2003 with any example
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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
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
