Linked database access

  • Thread starter Thread starter Leif
  • Start date Start date
L

Leif

I have a database that is being used my multiple users and is using Access
security. For a particular user I would like to provide them with a
different database that is table linked to the primary database. This ad hoc
database will allow the user to create their own queries and reports.
However, I do not want to all the user to be able to update the primary
database through his linking.

What is the best way to implement such a scheme? I don't see any parmeters
that allow me to set the linked tables as read only. Any suggestions?
Thanks.
 
You can create the new database, secured with the same mdw.

Assuming you have denied all permissions on the tables, create a RWOP query
for each table, and give the user only Read Data permission on the queries.
 
Back
Top