Link to another Access database with Read Only access

[epowell74]

Is there a way that I can link to another Access database, but only allow
read-only access through the link? The idea is that the person who has
access to the main database (through Network Security) would be able to
modify the data. The others would only have access to vew the data because
their access would be limited to the database that contains the link. I
tried to link through ODBC instead of browsing to the file, but when I did
that I received an error that said you cannot link to another Access database
through ODBC.

Thanks in advance for your help,
Emily

 

[Joan Wild]

Is there a way that I can link to another Access database, but only allow
read-only access through the link? The idea is that the person who has
access to the main database (through Network Security) would be able to
modify the data. The others would only have access to vew the data
because
their access would be limited to the database that contains the link.

You can accomplish this by implementing user-level security. Study up on
it:
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

 

[epowell74]

I wanted to avoid user-level security because of the maintainability factor.
We'll have many people using this and I don't want to set up user accounts
for each one. Is there any other way to accomplish this without user-level
security?

Thanks,
Emily