Importing table relationships from one database to antoher

[clancy76]

Hi there - I am working with an mdb that once had multiple table relationships defined - through corruption or some other means it appears that the relationships have disappeared. There is an older copy of the database that has the relationships defined, but of course the table data is out of date, so unfortunately I can't just import those tables into the other database. Is there a way I can move the table relationships from one database to another without actually copying over the tables? Apologies if this question has already been addressed, thanks.

[ranman256]

If its out of date, then you probably can't EVEN if you could.

[clancy76]

I'm sorry - when I said the "table data is out of date", I just meant the records, not the table structure - the table structure is the same, if that makes any difference.

[CJ_London]

you can create a new db and import tables (structure only) and relationships from your out of date system, then append the data from your current system.

Only concern is your db is .mdb but you are using 2013 - you may have to go back to 2003 for it to be successful

[clancy76]

Thanks Ajax. Yeah, I guess I just have to decide what the bigger pain in the neck will be - appending the data to new tables or redefining all of the relationships(there are a ton). Will think it over, thanks again.