Error

[qassim]

Hello,
I am using vb6 and using dao data control
with office 2000 when I connect with data control
to access 2000 it gives a error
(Unrecognize format) plz help me
Thanks

[honeybee]

Try using DAO 3.6 or higher.

[P.S.W.]

Hmm... I know what you're talking about and have never been able to get DAO to recognize Access 2000 DB either, even using DAO 3.6, as previously suggested.

You might try doing one of the following:

1. In Access, under the "Tools" menu, select "Database Utilities -> Convert Database -> To Prior Access Database Version". Now the DAO control will recognize it -- however, you will not be able to reformat queries and tables from inside Access once its converted -- so do this as a last step and you'll be OK.

2. Switch over to ADO. If you use Jet 4.0 in the connection string Access 2000 DB will be accepted.

Hope this helps.