Can VB6 only link to access97 but not work with accessXP?
and can i use vb6 in windowsXP?
laoli
0
Light Poster
Recommended Answers
Jump to Post8) I used to have the same problem too!
Before I give you suggestions, what operating system are you running?
Jump to Postlaoli said it already ... WindowsXP
Jump to PostDim CN As New ADODB.Connection Dim RS As New ADODB.Recordset Dim F1 as string CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\db1.mdb;Persist Security Info=False" CN.Open RS.Open "select * from Tablename", CN, adOpenKeyset, adLockOptimistic F1 = Rs(0) ' first field value in the first record
Jump to PostYou also may need to download Visual Studio 6 Support Pack 5
Available here: http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp5/default.aspx
All 13 Replies
Tekmaven
258
Software Architect
Team Colleague
8) I used to have the same problem too!
Before I give you suggestions, what operating system are you running?
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
laoli said it already ... WindowsXP
Tekmaven
258
Software Architect
Team Colleague
Dim CN As New ADODB.Connection
Dim RS As New ADODB.Recordset
Dim F1 as string
CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\db1.mdb;Persist Security Info=False"
CN.Open
RS.Open "select * from Tablename", CN, adOpenKeyset, adLockOptimistic
F1 = Rs(0) ' first field value in the first record
Tekmaven
258
Software Architect
Team Colleague
You also may need to download Visual Studio 6 Support Pack 5
Available here: http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp5/default.aspx
laoli
0
Light Poster
Thank you,you are of great help
jireh
3
Posting Whiz
Can VB6 only link to access97 but not work with accessXP?
and can i use vb6 in windowsXP?
It can be, All of them! Just chhose the higher version reference of your DAO or ADO.
cy_spiker18
0
Newbie Poster
It can be, All of them! Just chhose the higher version reference of your DAO or ADO.
hi! can you help me about ing programming?
jireh
3
Posting Whiz
hi! can you help me about ing programming?
What's the problem? why don't you post it here so the people can help you...hehehe I'm not geek! I'm only a beginner:D
debasisdas
580
Posting Genius
Featured Poster
from vb6.0 u can connect to all versions of ACCESS.
jrkryst07
0
Newbie Poster
i think i have a solution, instead of using OLEB.4.0 try changing it to OLEDB.3.51 if it works it only means that ur using a lower version of MS Office.
AV Manoharan
0
Junior Poster
from vb6.0 u can connect to all versions of ACCESS.
Dear Das,
Please ask Laoli what type of Connection (DAO or ADO)
he/she has used to gain access to Access database. conspicuously
he/she is silent after starting the thread.
regards
AV Manoharan
debasisdas
580
Posting Genius
Featured Poster
If dont think any one is still using DAO.
If one does he /she is simply dumb.
jireh
3
Posting Whiz
Why? is there any difference how you connect your database? if it is DAO or ADO?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.