automate backup of data

L

leaf

Hello there,

What is a good method to back up data stored in
the "tables" of an ACCESS database?

Thanks,

Yeying
 
D

Dennis Schmidt

Hi Yeying,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

In versions of Access prior to the latest Office 2003, there is not a built
in method of backing up an Access database. Because you have to have
exclusive control of the database, it makes it unpractical to try to back
it up during the day.

I would suggest using the System Tasks administrative tool to create a task
to do the job during the evening when no one is using the database. You
simply create a .bat (batch) file that does a copy of the database from one
location to another and then use System Tasks to schedule when the task
will run.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top