Relink Tables

[amishra]

Hi,

I have a startup screen which checks the connection of all linke
tables every time it runs. My problem started yesterady when i tried t
implement some security features using diff work group files. M
startup screen tells me to reconnect every time to link tables eve
though i am connected. I i give full rights to users groups in backen
database then startup doesnt flags me to reconnect.

Had gone thru microsoft "SECFAQ.doc" , didnt understand anything ab
relinking the tables.

Any ideaa to solve this using diff user group levels

Regards
Ami

 

[Brendan Reynolds]

From memory, I believe users need change design permission on the linked
tables in the front end (not the actual tables in the back-end data MDB).

It's been a while, though, so if anyone knows different, please don't
hesitate to say so.

 

[amishra]

Brendan

Giving design permission doesn't works.
Any other solution

Ami

 

[Brendan Reynolds]

If that didn't work, I'm not sure what the problem is, but perhaps I can
offer a suggestion as to how to narrow down the problem. Temporarily grant
full permission on both the tables in the 'back-end' data MDB and the linked
tables in the 'front-end' application MDB. Verify that the relinking works
as expected. Now begin removing permissions from the tables in the data MDB,
one at a time, starting with the higher-level permissions such as
administer, and checking that the relinking still works after each change.
If you successfully remove all permissions from the tables in the data MDB
and the relinking still works, repeat the process with the linked tables in
the application MDB. When the relinking stops working, the last permission
you removed is the one that the users need to have.

 

[go]

Brendan

Giving design permission doesn't works.
Any other solution

Amit

 

[amishra]

Got it done.
Gave open/run rights on database and open rights on tables.
It works now.

Cheers
Ami

 

[rikina]