Multiple Users Deleting records from the same table

[DaveK]

I have a database application that allows multiple users to open it at the
same time. There are 2 primary users who open the same form at each of their
desktops to delete records from the same table based on account and policy
numbers they supply on the form. If one of the users is already in the form
and the second user opens the same form the controls that display the account
and policy numbers show '#Deleted' in them.

My question is - is it good practice to have 2 users accessing the same
table to delete records? Is there a way to adjust the VB code behind the
'delete' button to prevent the above from happening?

Thanks for any help you can provide.

 

[Rick B]

I guess my question would relate more to your business practices than the
database. Why are two different users going to a databse and deleting
items? Do they just race to see who gets it first? Why not divide the work
in some logical manner so UserA does not have the same list or records to
delete as UserB?

 

[DaveK]

The users in question are deleting records for 2 different accounts - one
user is repsonsible for one set of accounts while the second users is
responsible for a different set.

 

[Sharkbyte]

As far as VB Code, assuming you don't change usage and structure (though Rick
has some valid questions) you would probably want to try the Requery action
on the records display object. Though I'm not sure what event you would
trigger that from...

Sharkbyte

 

[Rick B]

Then how would they step on each other?

 

[DaveK]

I'm not sure they are stepping on one another. My feeling is that it may be
a network performance issue. I was concerned about whether or not this was a
commonly accepted practice - multiple users hitting the same table in an
Access application.

 

[Rick B]

Yes, very common. Almost all databases would involve more than one user
hitting a table.