Can relationships be exported?

[dtburdick]

Is it possible to export relationships from one database (development) and import them into another (test).

I have to do it again on the move to production.

 

[karmahum]

Yes...

It is possible. On the IMPORT form that pops up when you are importing objects from one Access database to another, click the ADVANCED button and it will display some additional check boxes...Ensure that the IMPORT RELATIONSHIPS button is clicked...

And obvisouly, ensure that you are importing all the tables that you would like to maintain the relationship for...

I hope that helps.

 

[dtburdick]

Excellent. You just saved me a lot of work.

Thanks!