I have a problem making a Data Base Application. I am using Access 2000 and VB6 but I am getting an error message that says "Unrecognized Database Format".
Printable View
I have a problem making a Data Base Application. I am using Access 2000 and VB6 but I am getting an error message that says "Unrecognized Database Format".
Welcome to the forums. :wave:
If you are using Access 2000, then my guess would be that the database you are using was probably made in Access 97 or earlier.
Normally Access 2K can open a 97 db, usually prompting you to convert it to 2K. Not sure if connecting through VB behaves differently, or what a pre=97 db would do. I typically see the "Unrecognized..." error when trying to open a later db version in an earlier one, i.e., opening a 2K db in 97. Besides Hack's answer, was the db created in Access 2003 or later?
Access 2000 also uses ADO by default, not DAO. If you're using DAO code in your VB6 app, you're likely to get an error.
Er... ADO / DAO doesn't matter - uses both (create a new mdb and check the references.
I think you meant that if you are using vb the dao referenced may be the older one (3.5?) instead of 2003's one (3.6?).
If you are using ADO - check your connection string.
I thought 97 used DAO, 2K used ADO (unless you referenced DAO), and above that both are present by default. But the only VB versions I've used in a long time is .Net & VBA.
Qualinwraith,
You need to use the appropiate connection string. What does your connection string look like.
salvelinus,
You can use ADO or DAO with either database.