Locking database

[rundmcnj]

I have made a database with tons of information in it. THere is an auto
number. My question is , is there a way to freeze data in this database so no
one can change it and only make new entries?

 

[Jerry Whittle]

You will need to implement user level security to do that and really lock
down what certain users can do. It's a real pain to do so.

You could hide the table after creating a form based on it. Set the form's
Data Property for Data Entry to Yes. That will only allow new records to be
entered. They won't be able to see existing records. However a somewhat
knowledgable user will know how to bypass the form and get to the hidden
table.

 

[Stockwell43]

As Jerry said the user security is a bit complicated and a pain. However, a
shortcut would be to disable the form after update so in otherwords, have the
form open to a new record on open. After the user enters the data and clicks
the Add Record button the form will disable so when you scroll back to
previous records they are locked and cannot be updated. You will want to put
a password field and button on the form so ONLY those people who have edit
rights can enter the password, click the password button and enable the form
for editing.

What's unfortunate is I can't seem to find the database I had the code in
because I had one set up like that and worked great. But at least the idea is
there and if you do a search in this forum for Disable and Enable fields,
password field, password button and so forth you will probably find what you
need. If I come across that database, I send you the code and how to set it
up.

Hope this helps!!

 

[Fred]

Another idea, except lower tech.

A "view only" form to look at the data.

An "enter a new record form" which loads the first and only record in an
intermediate table.

Exiting appends that record to the main table and then delets it in the
intermediate table.