Seems when usoft upgraded, somewhere between office 95 and 2002, they changed the way docmd.copyobject works. Now, it not only copies tables, it copies all relationships as well ! I was using it to copy tables, then I would edit the (copy) tables and eventually resave data from them back to a master table. But now, when I delete records from the copy, it deletes data from my db ! Thats because I now get the stupid relationships. That did not happen w/ the 95 version of access. Wondering if there is a way to copy a linked table without copying the relationship info ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
copyobject method problem with linked tables
- Thread starter nayborbob
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question