Linked database access

[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.

 

[Joan Wild]

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.