How do I make an access database "lock" after data is entered?

[Guest]

I have a database that multiple people are entering data using a form. How do
I make the data "lock" after it is entered so that it can NOT be deleated or
changed by another user? Or can I make the database open to a "new" form and
not allow it to go to any other data?

 

[Brian Bastl]

Use the form's On Current event. I think something like the following will
work:

Me.AllowEdits = Me.NewRecord
Me.AllowAdditions = Me.NewRecord
Me.AllowDeletions = Me.NewRecord

Brian

 

[Joseph Meehan]

I have a database that multiple people are entering data using a form.
How do I make the data "lock" after it is entered so that it can NOT
be deleated or changed by another user? Or can I make the database
open to a "new" form and not allow it to go to any other data?

To keep them from getting to tables etc you will need to implement User
Level Security.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

Are these users working on the same machine or are they working from
their own machines? If on a LAN do you have a "split" database?

Another approach might be to use a batch method where they enter their
data and then it is sent to the storage table, likely in another database,
at the end of their session.

There are any number of possible ideas depending on the exact situation.

 

[Guest]

Well, here's a quick method to somewhat protect existing data in a table.
Set the Form's Data Entry property to Yes. When this form first opens,
existing data cannot be displayed. Only data entered during that current
work session can be accessed, as long as the user doesn't stray off your
Form. As an additional measure, you might also want to set the Form's Allow
Edits and Allow Deletions properties to No. This would prevent edits and
deletions to completed records visible to the user. Depending on your users
abilities and curiosity, this may be enough security.