Is it possible?

Question

Is it possible to auto backup an Access 2010 database to different server on a network?

Answer 1

Hi. I don't see why not as long as you have access to the servers on your network. What have you tried?

Answer 2

Hi. I don't see why not as long as you have access to the servers on your network. What have you tried?

I tried writing a vba script, but it doesn't like the path.

---

"A computer lets you make more mistakes faster than any invention in human history -- with the possible exceptions of hand guns and tequila." Mitch Ratliffe

Answer 3

Hi LibraryTechChik,

For your requirement, I think there are two ways, one is to copy the entire Access 2010 database file to different server, and another way you could use Application.CompactRepair method.

For Application.CompactRepair method, you could refer the link below:
# Application.CompactRepair Method (Access)
https://msdn.microsoft.com/EN-US/library/office/ff193242.aspx

Based on your description, it seems your target path would not work. I suggest you check whether you could manually copy the file, and check the server path whether it is correct.

Best Regards,

Edward

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 4

Would you mind showing us the code  you created?