TransferDatabase method

[Terri]

Is there an option in the TransferDatabase method which enables you to import
an object with the same name (in this case, an updated version) from one
database to another, and overwrite the old object with the new one?

Right now, the default is that Access puts the imported object into the
database with a "1" after it, but I'd prefer to overwrite the old object.

Thanks--
Terri

 

[Arvin Meyer [MVP]]

You can't do that. But you can delete the original object, then import the
new one. Something like:

DoCmd.SelectObject acReport, "rptReportName", True
DoCmd.DeleteObject acReport, "rptReportName"