CopyObject without overwrite prompts

[madkowrmd]

I am trying to use CopyObject in code to transfer various objects from one db to another. However many of the have the same name and I am prompted if I wish to overwrite the existing file.
Is there any way to bypass these prompts so I can then copy multiple objects without having to have user intervention?

Thank you,
Shane Fischer
Data Warehouse Programmer/Analyst
Paterno Imports
fischersc@paternoimports.com

 

[Dustman]

You might try using the setWarnings method.

DoCmd.SetWarnings False
'your code
DoCmd.SetWarnings True

I think that will stop them. -Dustin
Rom 8:28

 

[Dustman]

I forgot to mention.. there are a few warnings you should read before doing this. Look up "SetWarnings Method" in the help file and read the warnings first. -Dustin
Rom 8:28

 

[madkowrmd]

Thank you very much that worked...


"And we know that in all things God works for the good of those who love him, who have been called according to his purpose."

Thank you brother..

Shane Fischer
Data Warehouse Programmer/Analyst
Paterno Imports
fischersc@paternoimports.com