How do I backup a table to another database with a macro or code?

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

Guest

I want to put a button on the main switchboard to copy a table from the
current database to a backup database in another location.

Also do I have to tweak Access to see a database on a server to backup to
it? It seems to have difficulty locating the file on the server.

Thanks!
 
This is the basic code to create the table in the mdb specified in strFile:

strTable = "Table1"
strFile = "\\Server1\MyPath\MyFile.mdb"
strSql = "SELECT * INTO [" & strTable & "] IN """ & strFile & _
""" FROM [" & strTable & "];"
dbEngine(0)(0).Execute strSql, dbFailOnError
 
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

Access Deleted Table after Compact and Repair Database (Access 2010) 0
backup of database with multiple backend data bases 5
Difference in size of actual access database and its backup 0
schedule backup database 1
My Database and Backup have been moved to another location 3
Stopping a code to delete a table 2
Button to backup 2
Import multiple forms, queries from another database 1

Back
Top