Something with VB

[laoli]

Can VB6 only link to access97 but not work with accessXP?
and can i use vb6 in windowsXP?

[Tekmaven]

8) I used to have the same problem too!

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

[cscgal]

laoli said it already ... WindowsXP

[Tekmaven]

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]

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]

Thank you,you are of great help

[jireh]

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]

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]

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]

from vb6.0 u can connect to all versions of ACCESS.

[jrkryst07]

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]

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]

If dont think any one is still using DAO.
If one does he /she is simply dumb.

[jireh]

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