Access Mulit users in form keep stumbling over each other

[Whacks]

I've got a front end Access database that has the form and a backend
Accessdatabase that has the data. I would like mulitple users to be able to
enter information into the form but they keep stumbling on each others work
when they are doing so. My database is very simple, the table has 2 columns
one has the account number of customers and the other is where the workers
will fill in Yes or No. The users open the form copy the account number,
enter it into a program, and review it. If they account is positive for what
they are looking for, they mark yes or no and go onto the next record. I've
tried changing the Record Locks on the form to "Edited Record" but since some
can go faster then other by the time one can get in to edit (so Access can
lock it) the Yes/No box, another user has gone in and changed it, then the
slow users form freezes up. Is there a way to lock the record that's
currently on the form so that other users can't get into it?

 

[Arvin Meyer [MVP]]

1. Lock the table (All records) and there will only be one person allowed at
a time.

2. Use unbound forms which will allow records to be changed on when a record
is committed. It won't stop one user from over writing another.

3. Add a column to the table (yes/no) that when checked, will keep anyone
from editing the record. Use a query that is requeried in the form's Current
event.

Select * From MyTable Where MyYesNoField = False

Now users won't even see the records that have already been edited and
locked.

 

[Whacks via AccessMonster.com]

thanks for answering Arvin but I guess I do have some questions

1. When you say Lock the table, what do you mean by that? I went to the
properties of the table and didn't see a way to lock it.

2. So I start with a form that not attached to a table, but how do I "allow
records to be changed on when a record is committed"

3. got this part

 

[Arvin Meyer [MVP]]

With the Database open go to Tools >>> Options >>> Advanced tab and set the
Default record locking to All Records. The form is unbound and can only be a
single form view (no subform) When you are done editing, you press a button
which runs an Update query, usually in code, to write the record back to the
table. Like:

Sub cmdUpdate_Click()
Dim strSQL As String

strSQL = "UPDATE tblItem SET Cost = " & Me.Cost & ", ContractorID = '" &
Me.txtContractorID & "', EffectiveDate = '" & Me.txtEffectiveDate & "',
Where ItemID=" & lngItemID

CurrentDb.Execute strSQL

End Sub