How can I convert MS Access DB from verion 97 to 93? Is this even poss开发者_JAVA百科ible? 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.
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.
精彩评论