docmd.copyobject

[tted78]

I've been using "docmd.copyobject" in Access 2000 to copy a series of tables
from one database to four other databases without any problems. Now that I
have converted to Access 2007, the vba instructions do not work. I am first
asked if I want to replace the subject table in the destination, but then I'm
told that I can't replace it because it is participating in one or more
relationships. Can anyone offer any suggestions to make these vba
instructions work?

Thanks....Ted

 

[Alex Dybenko]

Hi,
perhaps you need to remove relation before copying? Anyway - I think better
approach - is to use delete and then append query to copy tables, then to
copy them using copyobject method

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com