Locking table data

S

Sandy H

Hi
I have created a database that has a number of linked tables. This database
will be allow users to create their own queries and reports. Aside from
using the User Level Security features in Access, does anyone know how else
I might be able to prevent users from changing data in the database.

I thought there might be something I could put in the linked table
connection string...

Any help would be appreciated
Thanks in advance
Sandy
 
J

John Smith

When you are creating the link, use a user id for the remote database that has
only SELECT permission, then the Access user will not be permitted to change
the data regardless of their Access permissions.
 

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

Adding data to MS Access from csv file 0
Table Security in Access 2013 1
Linking data in MS Word into Excel 5
"Compile error in table level validation expression " after format 0
could not update;currenty locked 1
Enable Iterative Calculations 0
Insert Index into a Table 1
Page numbering with Merged Document and IF statements 1

Top