CopyObject

[a]

I using this code to copy table to another data base

==============================================

The code

DoCmd.CopyObject "C:\mydb", "", acTable, "CODES"

==============================================

My Question is

Is there any way to copy relation between tables (((also ))))

 

[Tony Toews [MVP]]

I using this code to copy table to another data base
Is there any way to copy relation between tables (((also ))))

Yes but using the relationships collection and VBA code. Why would
you want make a table that is a copy of another table?

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/