Office 2000

When trying to open an access 2000 database I get a "Unrecognized database format". Now, I did convert this from Office 97?!?!? Any hints. Thanks so much in advance. Casox

Assuming you are using ADO - which you probably have to - use Jet.Oledb.4.0 as your data provider. Use this as your connectstring: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strAppPath & database.mdb & ";Persist Security Info=False"

Works for me.

Quote:

---

Originally posted by okdorje:
Assuming you are using ADO - which you probably have to - use Jet.Oledb.4.0 as your data provider. Use this as your connectstring: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strAppPath & database.mdb & ";Persist Security Info=False"

Works for me.

---

Thanks. However, I found this solution on MSDN but using the Jet 4.0 does not help. Perhaps I am not changing it in another area or something.