I have Access 97, 2000 and 2003 all running on a Win XP box after having
just reinstalled XP. Among other problems, I find that Access 97 will
not compact a database in code ...
DBEngine.CompactDatabase dbSource, dbDestination
... instead giving error 3001 - Invalid Argument. It worked happily prior
to the XP reinstall. (I have uninstalled all versions and reinstalled
again to no effect.)
This is the same problem I had a few years back with an older laptop.
See thread
http://groups.google.com.au/group/comp.databases.ms-access/browse_thread/thread/4dca655b30e0e93d/c403906208091269?hl=en&lnk=gst&q=compact+fails#c403906208091269
I didn't solve the problem then, and haven't found any more info in this
group since.
Anyone have any idea how I can get my Access 97 compact function back?
Owen Jenkins
