Rename/Save as function for entire database

[chriswatson78]

Hi,

I am running an autocompact module in Access97 which will created a 'compacted version' of my database. I then want to rename this compacted version to the name of the original database I compacted. I cannot however find a way of doing this in code.

Basically the idea is to compact every 45 minutes or so, but what my autocompact is doing is creating a compacted version under a different name, and so compacting a copy of the database, I then want to change this compacted database name to the original name and re compact every 45 mins


Can anyone help?

 

[boblarson]

I know that there are other ways to do it, but I never liked going through all of the hassle of doing the actual rename and such.

So, I've been using this code to auto compact, while still in the database, since Access 2.0 and it works in A2K, AXP, and A2K3.

        SendKeys "%(TDC)", False