Making records in an access table read-only

[Dave]

I want to define an access table so that records can be inserted into
it, but once inserted, they cannot be updated or deleted. Is it
possible to do this, and if so, how?

Thanks in advance.

 

[Guest]

You would first need to implement user level security and lock out the
database window for most users.

Then you create a form with Allow Edits and Allow Deletions turned set to
No. Allow Additions set to Yes. You'll have to decide about the Data Entry
property of the form.

Next you'll want to split the database so that the tables reside in another
MDB file. Make sure to at least password protect this Back End file.

Lastly convert the Front End mdb file with the forms and reports into an MDE
so that no one can mess with the form's properties.

While you are comtemplating all this work, and it's a lot of work, ask
yourself if it might just be better to trust your users......

 

[Granny Spitz via AccessMonster.com]

I want to define an access table so that records can be inserted into
it, but once inserted, they cannot be updated or deleted. Is it
possible to do this, and if so, how?

The cheapest way is to use User-level security to remove users' permissions
from the table, but it requires some work on your part to implement correctly
and securely. If you don't want to implement User-level security, then you
can block table edits by making the table's datasheet read-only.

I use a developer's productivity tool Add-In that I bought for $35 from one
of the web sites I found in the links of people who answer questions in this
newsgroup. The tool has lots of buttons and one of them blocks table edits
by making the records in the datasheet read-only. The records in the
datasheet can't be updated, deleted, or have new ones added. The Add-In tool
also has a button to unblock table edits, so you can do administrative work
on the table's data if need be, and then block table edits again afterwards.
Whether the table's records are blocked or not, you can still go into design
view and change the table's columns' properties. The table itself isn't read-
only, just the records in the datasheet view are. The way to insert new
records is to use a bound form. Use the form's properties to prevent record
deletions and edits, or use VBA to lock the controls for existing records,
but unlock the controls when the user is adding a new record.

I'd give you the URL, but the newsgroups prohibit advertising.