How to keep edit rights after relink?

[Hallgeir]

In my mdb file I have linkes to some views in a microft sql database. For
one of this linkes I want to keep the rights to do changes. When I link the
view by using File, Get External date, and Import I'm allowed to select a
primary key for the view and thereby I get the rights to do changes to this
linked view in my access application. My truble is that everytime I relink
my views (link table manager) I loose the privelegium to do changes. Is
there a way around this problem? How can I keep the rights after a relink?

I appreciate any tips or hint that could help me!

Regards
Hallgeir

 

[Hallgeir]

In my mdb file I have linkes to some views in a microft sql database. For

one of this linkes I want to keep the rights to do changes. When I link
the view by using File, Get External date, and Import I'm allowed to
select a primary key for the view and thereby I get the rights to do
changes to this linked view in my access application. My truble is that
everytime I relink my views (link table manager) I loose the privelegium
to do changes. Is there a way around this problem? How can I keep the
rights after a relink?

I appreciate any tips or hint that could help me!

Regards
Hallgeir

I just discovered an error in my description above. When I linked the view I
used Fil, Get external date and Link table (of course).

Regards
Hallgeir