save the information in my database

[Guest]

I'm about to finish my database and I will start using it very soon. However,
I want the information, once entered in my database, to be saved. In other
words, I would like all the information not to be changed if somebody by
mistake start overwriting the information. For instance, if I have 20 new
records with information in my form, and if somebody instead of staring in
record 21 begins at record 1 I want access not to let that person change the
information already in the database. How can I do that?
Miguel

 

[Rick B]

One way is to make the form they use a "data entry" form so they can add
records, but not see or change. Another way would be to make the form
default to a new record rather than the first record.

 

[Guest]

Rick B has some very good suggestions; however, if your users can get to the
tables, they still can mess with the data.

To make 99.99% sure that no one but you can change the data, you'll need to
put in user level security and grant permissions to do certain tasks. This is
not easy to do and a lot of work.

If you just need to be 95% sure that no one messes with the data, I'd
certainly use Rick's ideas.

Also make a nightly backup of the MDB file to another media. This is a very
good idea if someone messes up your data; the server dies; or you have a
corruption problem.

 

[Larry Daugherty]

Open your form in design view. Look at the properties. Turn off
Allow Edits. Look at the other properties to wee what you'd like.
You'll have to make provision for changes in case of errors on entry,
etc. Don't depend on getting directly into the tables to do it.

HTH