Copy tables and their relationships?

[webmeister]

I know it's possible to copy tables from one .mdb to a blank .mdb. Is it also possible, in either VBA or VB to also copy the relationships that existed in the original .mdb?

If it is possible, how would that be done? If anyone has a sample, I'd love to see it.

Thanks so much for your time and effort. Looking forward to hearing back from you!!

 

[Rickster57]

db to db

Check this beast out


http://support.microsoft.com/kb/298174

 

[webmeister]

Rickster,

Thanks for your reply! That was an interesting bit of info, on the link you provided. I can use it in future projects.

Unfortunately, what I was trying to do was in Visual Basic, not VBA, so some of the code wouldn't work. I did end up getting it figured though.

But again, thanks for replying....I appreciate it. Have happy holidays!