Multiple Users

[auujxa2 via AccessMonster.com]

Let's say I buy merchandise for 1 department.

I have dozens of users (for different departments), who import data (using a
form) from 1 source database (in which they do not see).

Upon importing the source data (their department info), they manipulate it,
then delete the relevant old data in the source, and replace it with the
newly manipulated data.

My question is:
Is there any chance of data deletion with multiple users hitting the source
at the same time?

Meaning, if I am only deleting and replacing MY department, it shouldn't
affect other data in the table?

We've run into data loss issues in the past, I want to make sure it isn't
because of one user deleting records while someone at the same time is
importing or updating themselves.

Thanks

 

[KARL DEWEY]

Why not add a 'flag' field so indicate old/inactive data and not delete
anything.

Include a criteria in all queries to exclude old/inactive.

 

[auujxa2 via AccessMonster.com]

The database is already huge (records-wise). We are talking about over 300
stores, 200 departments, thousands of skus per store.

If it was access 2007, I'd consider it, but we're not that lucky.

Can records be deleted if multiple users are updating a table at the same
time?