Back up Tables

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

Guest

I am new to Access programming. I want to back up a table from database1.mdb
to database2.mdb without opening either of them, but working from
database3.mdb.
I tried DoCmd.copyobject method which doesnot allow for specifying the path
of database2.
I tried transferdatabase method, which aloso doesn't seem to allow
specifying path of database2.
Can anyone help me with this?
Thank you.
Toyfixer
 
ToyFixer said:
I am new to Access programming. I want to back up a table from
database1.mdb
to database2.mdb without opening either of them, but working from
database3.mdb.
I tried DoCmd.copyobject method which doesnot allow for specifying the
path
of database2.
I tried transferdatabase method, which aloso doesn't seem to allow
specifying path of database2.
Can anyone help me with this?
Thank you.
Toyfixer
Click to expand...

Use linked tables and action queries in database3.mdb.

Keith.
www.keithwilby.com
 
Thanks Keith, but when I try to backup using link tables, I realised only the
link is being backed up. The original file stays at the same location. When
the original file was deleted, the backed up link doesnot work.
Therefore I used three steps which involves transferspreadsheet method.

step 1 Import the table to database3.mdb
step 2 export the table to database2.mdb
step 3 delete the table in database3.mdb

Excuse me for my ignorance but I still don't knowwhat an action query is.

Thanks for the consideration anyway.
Regards
Toyfixer
 
Back
Top