How can I convert MS Access DB from verion 97 to 93? Is this even possible? Any help/suggestions would be appreciated.
EDIT:
I'd like to take a full database (tables w/data, queries, forms and reports), but not the code.
A:
You won't be able to use the following as Remou found the relevant sentence in the help.
DBEngine.CompactDatabase "olddb", "newdb", , dbVersion20
where dbversion11 could be dbversion10 for Access 1.0 and dbVersion11 could be for Access 1.1.
Now I just tried this in A97 on my own system and I doubt it worked. When I opened up the "newdb" I didn't get any kind of message telling me I was opening an older version or offering to convert it for me.
I poked about in A97 and the help and couldn't find any means of backwords conversion. So I suspect David is correct in that there was no going back.
Edited as per Remou's comment.
Tony Toews
2010-02-25 21:42:44
From 2000 Help "You can specify only one version constant. If you omit a version constant, newdb will have the same version as olddb. You can compact newdb only to a version that is the same or later than that of olddb."
Remou
2010-02-26 20:00:49
Ah, I missed that last sentence. So this won't work then.
Tony Toews
2010-02-26 21:31:35