backup open access files

[OM]

Hi,

Our users tend to forget close their access application when they finish
their work at the end of the day. Therefore the ntbackup program always
failed to backup the access database files on the file server.

Can you someone recommend me a way to backup these open files? Do I
really have to look for a backup program that support backing up open files?

Thanks

 

[John W. Vinson]

Hi,

Our users tend to forget close their access application when they finish
their work at the end of the day. Therefore the ntbackup program always
failed to backup the access database files on the file server.

Can you someone recommend me a way to backup these open files? Do I
really have to look for a backup program that support backing up open files?

Thanks

Rather than backing up open files (a risky idea!), close them instead. See

http://support.microsoft.com/?kbid=128814

for a technique to detect when a database has been sitting idle for too long;
just run Application.Quit when you find a database that's been doing nothing
for an hour or so.