Backup/Restore Backend from Frontend

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to backup and/or restore the backend from the front end.
Can this be done?

If yes, could someone please point me in the right direction?

I've been searching on my own, but am unable to find a proper solution.
 
Provided there are no open recordsets based on your back-end tables, you can
do whatever you like with the back-end file.

Two possible options are a simple copy of the file:

FileCopy <path to backend>, <backup file name>

or create a compacted copy:

DBEngine.CompactDatabase <path to backend>, <backup file name>
 
if you used an ACCESS DATA PROJECT you wouldn't have to worry about
this simple annoying crap

compact and repair shit

it's 2005 welcome ot the 90s
start using ADP
 
You must log in or register to reply here.

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

Similar Threads

Frontend and backend database question 11
Need a little advice on frontend - backend set up... again. 1
Backend/Frontend Issue 2
Generate a new backend 2
Access and Oracle backends 8
Linking to Access 2003 tables from Access 97 frontend 3
Good (recent) books on MS SQL Server backends + MS Access frontends? 6
Loosing data when entering data to backend. 21

Back
Top