Time to transfer data in EasyHID

[keithdoxey]

Now I'm getting back in that VB6 tutorial I started a few months ago; I'm at the database access section. I defined a basic database for my application in Access (saved in 2000 format), but I'm getting an error when I try to use it in VB6; something about unknown database format. I figure VB6 can only read an older format like Access97 which probably means having to work in Windows '98 again.

Access 2000 works fine with VB6.

Add in Component "Microsoft ADO Data Control 6.0 (OLEDB)"

I have the following declarations in my project

Dim adoConn As New ADODB.Connection
Dim adoRS As New ADODB.Recordset

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
strConn = strConn & "K:\HTML\db\KAT5AV.mdb"
adoConn.ConnectionString = strConn
adoConn.Open

Its a couple of years since I wrote that program but I am pretty sure that your problem is the provider. I think Access 2000 needs Jet4 whereas Access97 was Jet 3.5.

You definately dont need to revert to Win98 as I am running XP.

I actually have a web front end for the database which I use for entering and editing data, my VB app only reads the database for sending commands out of a Comm port although there is no reason why it could be done the opposite way round with VB receiving data and inseeting records into a database that could then be read on a web browser.

Any updates you need including service packs for VB6 should be on the Microsoft website.... somewhere!!!!

HTH