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

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



"tted78" <(E-Mail Removed)> wrote in message
news:8EC3264B-3320-4A09-8A3B-(E-Mail Removed)...
> 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