8
Contributors
13
Replies
14
Views
13 Years
Discussion Span
Last Post by jireh
1

8) I used to have the same problem too!

Before I give you suggestions, what operating system are you running?

0
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
0

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.

0

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?

0

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

0

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.

0

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

0

Why? is there any difference how you connect your database? if it is DAO or ADO?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.