Automatic Backup after particular time Duration.

Question

User492839198 posted

hi all

I am using MSACCESS as back end.

And as we can get database back up in the SQL server after particular time.

I want that kind of back up in MS ACCESS.

How can i get it..

Thanking You,

Harshad Mahant

Answer 1

User849259894 posted

 Access does not provide automated backup out of the box.  There are third party components that can do the job.

One easy way is to write a batch file to copy the file from one location to another and then use the Windows Scheduler to run the batch file at regular intervals.

Remember that copying a open mdb file is going to fail and so if the database is in use then you have to think about a strategy for the backup.

Answer 2

User-1199946673 posted

Remember that copying a open mdb file is going to fail

 

Really? I copy many open mdb files every day without any problem!!!!

Answer 3

User492839198 posted

Can u provide me the batch file. And How can i set the Windows Shceduler.

Answer 4

User-1199946673 posted

Can u provide me the batch file. And How can i set the Windows Shceduler.

 

This really has nothing to do with ASP.NET! Ask your questions somewher else, or even better, use google/binq to find the answers on the nternet....

Answer 5

User-1675817941 posted

Hi,

this link may  helps you

http://www.mvps.org/access/modules/mdl0045.htm

http://bytes.com/topic/access/answers/424790-how-create-automatic-backup

 

Thanks,