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

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"ליאון ג''''ירד" wrote:

> 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

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

"Jerry Whittle" wrote:

> 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.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
> "ליאון ג''''ירד" wrote:
>
> > 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

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.

"ליאון ג''''ירד" <@discussions.microsoft.com> wrote in message
news:31F38049-E74D-4834-9EBB-(E-Mail Removed)...
> 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
>
> "Jerry Whittle" wrote:
>
>> 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.
>> --
>> Jerry Whittle, Microsoft Access MVP
>> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>>
>> "ליאון ג''''ירד" wrote:
>>
>> > 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