Export Table Using Transferdatabase While Its Still Open

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

Guest

I have a form which is based on a table. Is it possible to write VBA code
like the DoCmd.TransferDatabase to export the current contain of the table
out to another database?

I tried something like that, and it seems not to work. Once I close out of
the form (which releases the table), I was able to export the table to
another .mdb.

Can someone help!

Thanks,

Gary
 
Gary:

You can't call TransferDatabase while there is any type of record lock on
the underlying table. Perhaps this failed because your current record was
unsaved (hence locking the under lying table.)
 
Back
Top