Linked Table Security in MS Access

[excelCPA]

I have an Access database with several linked tables which link to a
second Access database. As it is currently setup, the linked tables
have update access to the original database, I want this to be ‘read-
only’ access. I do not own the original database and it has other
uses so the owner is not comfortable changing anything security
parameters in the original DB.

Are there any security parameters I can configure in my database
making my linked tables ‘read-only’ to the source data?

 

[Arvin Meyer [MVP]]

I have an Access database with several linked tables which link to a
second Access database. As it is currently setup, the linked tables
have update access to the original database, I want this to be ‘read-
only’ access. I do not own the original database and it has other
uses so the owner is not comfortable changing anything security
parameters in the original DB.

Are there any security parameters I can configure in my database
making my linked tables ‘read-only’ to the source data?

Sure, but you will need a copy of the workgroup file for the backend data on
the server. Just create a new workgroup with read-only Access for your
front-end.

You can have distinctly different security levels on the 2, but the
front-end must always be more restricted, or the same as the back. Here's
some security info:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm

 

[Alex]

Hello, excelCPA!
You wrote on Fri, 16 Oct 2009 05:36:18 -0700 (PDT):

e> I have an Access database with several linked tables which link to a
e> second Access database. As it is currently setup, the linked tables
e> have update access to the original database, I want this to be ‘read-
e> only’ access. I do not own the original database and it has other
e> uses so the owner is not comfortable changing anything security
e> parameters in the original DB.

e> Are there any security parameters I can configure in my database
e> making my linked tables ‘read-only’ to the source data?
1. You can ask administrator to set file (folder) Security Permissions for
linked database to read-only for you
2. You can use forms, where is possible to lock updates/additions for some
fields o? for all data.
3. As was described by Arvin Meyer

Alexey Semenov

 

[Alex]

e> I have an Access database with several linked tables which link to a
e> second Access database. As it is currently setup, the linked tables
e> have update access to the original database, I want this to be ‘read-
e> only’ access. I do not own the original database and it has other
e> uses so the owner is not comfortable changing anything security
e> parameters in the original DB.

e> Are there any security parameters I can configure in my database
e> making my linked tables ‘read-only’ to the source data?

1. You can ask administrator to set file (folder) Security Permissions for
linked database to read-only for you
2. You can use forms, where is possible to lock updates/additions for some
fields o? for all data.
3. As was described by Arvin Meyer

Alexey Semenov

 

[excelCPA]

I have an Access database with several linked tables which link to a
second Access database.  As it is currently setup, the linked tables
have update access to the original database, I want this to be ‘read-
only’ access.  I do not own the original database and it has other
uses so the owner is not comfortable changing anything security
parameters in the original DB.

Are there any security parameters I can configure in my database
making my linked tables ‘read-only’ to the source data?

Sure, but you will need a copy of the workgroup file for the backend dataon
the server. Just create a new workgroup with read-only Access for your
front-end.

You can have distinctly different security levels on the 2, but the
front-end must always be more restricted, or the same as the back. Here's
some security info:

Security FAQhttp://support.microsoft.com/download/support/mslfiles/SECFAQ..EXE

Lynn Trapp's summarization:http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:http://support.microsoft.com/defaul...upport.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:http://www.jmwild.com/security02.ht...NoLogin.htmhttp://www.jmwild.com/Unsecure.htm

Great, thanks for the info.