Links and security

[MikeM]

I have an Access database(OnHand.mdb) that I have linked to another Access
database(GetFiles.mdb).

I don't want anyone messing with the GetFiles.mdb so I gave people no
access. In my testing of the OnHand database it worked fine I have admin
rights to that folder. I tried it with another user account without access
to that directory and I get an error that the linked tables aren't working.
How can I get around giving the user any rights to the GetFiles.mdb
folder/file?


MikeM

 

[Tim Ferguson]

I don't want anyone messing with the GetFiles.mdb so I gave people no
access.

When you say "messing with"..?

In my testing of the OnHand database it worked fine I have
admin rights to that folder. I tried it with another user account
without access to that directory and I get an error that the linked
tables aren't working.

Well, no: if they cant access the file, then they can't access the data.

How can I get around giving the user any rights
to the GetFiles.mdb folder/file?

Use Access security: remove all permissions from the tables and moderate
all interaction with the data using WITH OWNER ACCESS queries.


Hope that helps


Tim F