Copy relationships

[fastrunr]

Hi,
Can anyone provide me with some guidance in copying relationships from one Access db to another. There was some sample code for this at:

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

It appeared to run successfully, but didn't produce any results.

Any help greatly appreciated.

 

[DrSimon]

Haven't tried the URL you posted, but surely it would be easier to copy the whole Access db and rename it. Any other work you have done could be imported from the existing one.
Simon Rouse

 

[fastrunr]

Yes, but I haven't been able to figure out how to do that without also copying the security information, which I *don't* want. However, I was finally able to copy only the relationships using the vb module I found at the following site:

http://support.microsoft.com/?kbid=304322

Thanks for replying!

 

[DrSimon]

Interesting - useful for the future. Thanks