CopyObject When Destination File Might or Might Not Exist

[Charles]

Hi,

Can you tell me how I can copy an Access table to a different name, say
Table2 when there is possibly (or possibly not) already a Table2 and I want
to write over the old Table2 if it exists?

Thanks

 

[Dirk Goldgar]

Hi,

Can you tell me how I can copy an Access table to a different name, say
Table2 when there is possibly (or possibly not) already a Table2 and I
want
to write over the old Table2 if it exists?

You can use the TransferDatabase method instead of CopyObject. For example,

DoCmd.TransferDatabase acExport, _
"Microsoft Access", CurrentDb.Name, _
acTable, "Table1", "Table2"

.... will copy Table1 to Table2 in the current database, replacing Table2 if
it exists.

 

[Charles]

Thank you for your quick and useful reply! It worked fine!