access 2003 MSysRelationships table problem

[לי×ון ×’''''ירד]

The problem is I deleted MSysRelationships rows in my MDB.
I have an old backup and I want to Import target MSysRelationships table but
it not updated in any way in source MSysRelationships table it's create a
new table named MSysRelationships1... a.

How to resolve the issue without having to manually create the relations.

Thanks
Leon jhirad

 

[Jerry Whittle]

Messing with MSys tables is like playing with fire: you can get burnt. Your
best bet is to create a new database file; import everything from the
original into it; then manually recreate the relationships.

 

[לי×ון ×’''''ירד]

thanks, This is good example,but...
my access table has been linked to ms-sql server tables.
becuse of this link all of the relations deleted from the mdb database.
i can't import all, i just need the relations from old db.

thanks
leon jhirad

 

[Paul Shapiro]

If the tables are all linked, delete the linked tables. Compact the db. Then
relink the tables, selecting all of them at one time. The relationships
should be imported with the links.

I would still follow the original advice to create a new db. System tables
are hidden because anything you do to them can damage the system. Safer to
create a new db. Then add the linked tables. Then import all the forms,
queries, reports, modules and macros from the old db.