problem with converting old mdb

[nivini]

I have this vb6 app i wrote 4 years ago connected to access97 mdb. Now i need to upgrade the app, it demands changes to the mdb, so I converted the mdb to access2000 version, BUT when I run the app an error arase "unrecognized database format (with the path to the converted mdb)".
so in order to avoid this error, I converted the mdb back to its former version, and it worked. but there are so many changes to the app, and in consequens changes to the mdb, that I can not do this conversion back and forth,
How can I convert it to access2000 version, so the code will not come up with the error "unrecognized database"?
waiting for your professionals solutions
TIA

 

[ClulessChris]

Just a guess, but I'd consider looking at your connection strings?

Everybody body is somebodys Nutter.

 

[nivini]

No, ClulessChris, that is not the connection string,
But thnks anyway for your replay.
Any other ideas?
TIA

 

[fredericofonseca]

the problem is the version of JET you are using. 3.51 will not open AC2000 files.

Upgrade you DAO version to be 4.0 and it will work.


And if you had gone to the trouble of searching the forums you would have found PLENTY of threads on that subject.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com