CODEWITHSUNDEEP
ms-accessms-access-97
Stone
Stone

Reputation:

Convert Access Database to 97 format

Is there a way of converting an Access Database into a 97 file format, using Access 2007. I know the GUI cant do it, and I have tried:

Application.ConvertAccessProject _ SourceFilename:="C:\cCentre\Database\CommDBBad.mdb", _ DestinationFilename:="C:\cCentre\Database\CommDB97.mdb", _ DestinationFileFormat:=acFileFormatAccess97

Without luck. Is there another method / tool ?

Thanks

Upvotes: 2

Views: 4518

Answers (2)

Tony Toews
Tony Toews

Reputation: 7882

Try DBEngine.CompactDatabase olddb, newdb,, dbVersion30

I can't test this myself due to a problem with A2007 on my system caused by some NTFS permissions corruptions problem.

Testing an empty A2000 database inside A2003 gives the following message: 3301 Cannot perform this operation; features in this version are not available in databases with older formats. so this probably won't work.

Upvotes: 0

DJ.
DJ.

Reputation: 16247

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 further convert it back to Access 97.

Good luck!

Upvotes: 2

Related Questions