Link to another Access database with Read Only access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

You could (instead of links) create queries in one MDB that pull data from
another MDB using the In() clause and then make the RecordSetType of the
query a Snapshot to make it read only.

SELECT *
FROM TableName
IN 'Path to external mdb file'
 
Back
Top