Links and security

  • Thread starter Thread starter MikeM
  • Start date Start date
M

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
 
I don't want anyone messing with the GetFiles.mdb so I gave people no
access.
Click to expand...

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.
Click to expand...

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?
Click to expand...

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
 
Back
Top