Data control error "unrecognised database format" on A2K DB

[John_Lamb]

I am trying to use the data control in VB6 to open a A2K database but I get the message
"Unrecognised database format". I'm sure I can change it with the references but I have tried this and failed.

Help appreciated

[d.paulson]

DAO 3.6 Object Library
ADO 2.5 Object Library

The lastest service pack (sp5) contains this.

David Paulson

[John_Lamb]

Thanks for responding, I'll get the service pack from the microsoft site.
I wasn't sure whether to use DAO or ADO for my system. It is basically a question system with tables stored on the local drive. It sends results to a management system accross the network when a test is completed. So there is little communication with the backend database. I'm still learning ADO and trying to avoid using it if possible. Antway I'm told that as DAO is the native language of Jet and will probably be more reliable.

thanks again

John Lamb

[Iouri]

If you are using both DAO and ADO in your program you have to define the recordset as
Dim rs AS DAO.Recordset
or
Dim rs AS ADODB.Recordset

When you are reffering to Db also use prefix DAO or ADODB.

Iouri Boutchkine
iouri@hotsheet.com