Converting Access Database to 97 Format
Is there a way to convert an Access database to 97 format using Access 2007. I know the GUI can't do this and I've tried:
Application.ConvertAccessProject _ SourceFilename: = "C: \ cCentre \ Database \ CommDBBad.mdb", _ DestinationFilename: = "C: \ cCentre \ Database \ CommDB97.mdb", _ DestinationFileFormat: = acFileFormatAccess97
No luck. Is there any other method / tool?
thank
According to this http://office.microsoft.com/en-us/access/HA102308221033.aspx you can only go back to Access 2000. Then you need a copy of Access 2003 or 2000 to convert it back to Access 97 later.
Good luck!
source to share
Try DBEngine.CompactDatabase olddb, newdb, dbVersion30
I cannot verify this myself due to A2007 issue on my system caused by some NTFS permissions corruption issues.
Testing an empty A2000 database inside A2003 gives the following message: 3301 This operation cannot be performed; functions in this version are not available in databases with old formats. so it probably won't work.
source to share