Compressing Files

[Guest]

Hi,
I am trying to automate the compressing of backup files from an access
application using VBA.
I have seen around the internet that this is possible but I simply don't
know where to start when it comes to constructing a function/procedure.
Also, it would be extremely helpful if you could tell me which references
need to be loaded in VBA to get it to work. At the moment I keep getting
errors on "DefaultFilePath", I assume this is because I don't have the
correct reference loaded. Anyway, thanks in advance for anyone who can
provide a full function. Cheers.

 

[Larry Daugherty]

From Acc97 you can set an option to compress the database on close.
Access 2003 offers a file option to backup a database. All database
objects must be closed and you must indicate a backup path.

Please indicate your objective and how you are trying to achieve it.
The errors "DefaultFilePath" doesn't really explain much. Are you
executing the VBA in the database you're trying to compress?

I've mentioned a couple of times in the Access newsgroups that I've
developed a utility that will automatically Backup, Compress and
Restore the current application, when the last user closes it; logging
every step of the process, I've never heard of anything else that
does the whole thing. There are several utilities out there that run
independent of the Access application, some that will even seek and
attempt to compress every MDB on your system. However they must be
manually run or run via the scheduler.

Post back here to continue your thread. If you'd like to explore my
utility, please decode my email address and take it out of the
newsgroup.

HTH