read-only linked tables

E

Erik

I have a database that is used by many employees. I want
to prevent them from being able to modify data on a linked
table that is housed in another Access Database. Is there
a way to make the linked table read only?

Thanks in advance.
 
M

Mark Mesarch

Hi,
I am trying to do some of the same things.
I have tired putting the original database and table in a
folder that the shared users have READ ONLY permissions
too. You have to make sure that the link is the correct
path. THen the database file that they are using is in a
a folder they have Write priveldges to.
Mark
 
D

Duane Hookom

You can create a query that links to another database. Then either set the
query to a Totals query or create a one record table and add the table to
your query. You can make the table hidden if you want so they only see the
query. If the user's find their way around this very simple security, you
may need to implement Access Security.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read Only now different 1
Embedded Excel into Word with Tables 0
Doughnut Chart linked with the slicer in the pivot table 0
Creating a Search using a combo box and then creating a report. 4
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Setting column width in a table with a macro is not working 0
Make Query or Linked Table Read Only 3

Top