Prev: Subform/Form Referencing
Next: Changing recordset based on multiple checkboxes
From: Terri on 3 Dec 2009 14:38
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
From: Arvin Meyer [MVP] on 3 Dec 2009 17:39
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"
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com



"Terri" <terri(a)discussions.microsoft.com> wrote in message
news:9F44B4D8-D5A3-42F1-859D-3A1E019104B5(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: Subform/Form Referencing
Next: Changing recordset based on multiple checkboxes