1. Using Access 97, compact the database: Tools | Database Utilities.
2. Decompile a copy of your database. Close Access. Find the path the the
Access 97 executable. Open a command prompt, and enter something like this.
It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "c:\My
Documents\MyDatabase.mdb"
3. Open the database in Access 97 again, and compact again.
Now try the conversion to A2000 again.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
mktse said:
I have a MDB with VBA in version 97. When open this MDB by Acc2k, the
software will ask for conversion and I say OK. However, everytime the
result is fail. Please advice.
