Click to See Complete Forum and Search --> : Any ultility for converting MS Access 2002 files to Access 97?


Xeon
September 10th, 2002, 04:11 AM
Now, I created a database using MS Acess 2000 in school, and when I wanna open this file using MS Access 97 at home, I got an error saying unrecognized file format.

I believe it's cos' the 2 versions ain't the same.
Does Microsoft offer any converters on it web site?
Or is there any other 3rd party tool out there? :D
I've tried searching for it, but in vain. Thanks a lot!

Chriss688Sub
September 12th, 2002, 08:16 PM
Have you tried openning the file at school with 2K and "save as" using the 97 format?

If it is pure C (C++) you might have to read and re-save using an old [ODBC driver? format?] I forgot the name, but you know

"What is ODBC, OLEDB, ADO, DAO, ...?"

But I think that using CRecordset you can specify many alternate format as long as the [driver?] was installed. Just make sure to specify the format after creating your CDatabase. I did this between Access and an old Excell format. S

earch MSDN it's not easy but their is some obscure reference somewhere. Search in the "Visual C++" forum, I beleive I asked around and I usually follow up with my solutions.


Good luck.

Xeon
September 12th, 2002, 10:23 PM
Thanks a lot, Chris! :):D