Make a linked Access 2002 "Read Only"

D

David Cash

I have an Access 2002 table within a database in one
directory. I have linked the table to several other
directories and databases for informational use.

When information is accidentally changed in a query, or
entry form, it changes information in the original table.

How can I make the original table "Read Only" so Linked
tables being read by Entry Forms and Queries can read the
data, but not change it. I have no security on these
tables, nor do I want any if not critical.

Please advise,

David Cash
(e-mail address removed)
 
N

Nikos Yannacopoulos

David,

If you don't want to implement security, then I guess you could play around
with the properties of the controls on the user forms: controls displaying
the data from that particular table can be set to Enabled > No and/or Locked
Yes, so the user can see the data but not change it even on the form.
Click to expand...

HTH,
Nikos
 

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

Sub projects added as read only in Master file which are saved on sharepoint 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2002 change report header text 0
How do I clear a form? 0
Access 2010 DB not fuctional with multiple users 2
Make Query or Linked Table Read Only 3
Link to excel table which has keys in both row and col headers: isthis possible? 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0

Top