Running Queries simultaneously via form

[ChobeyGuddu]

Hello,
I have a database which will be used by 15-20 employees - I have couple of Append Queries based on 1 field population (AFter update event- the code runs for Query running)

My question is - If I create a MDE file and distribute them to the 20 Employees and they all working on it at the same time.. does it makes database corrupt - if some of them are running same query (based on population of field & code runs)?



Pls advise,

Cheers
Chobey Guddu.

[ranman256]

I doubt any 2 employees will run at the exact same time.
plus, it's an append query. Nobody should get interference.

[pbaldy]

I assume you mean the application is split, so you'll be giving each person a copy of the front end? As a rule, I wouldn't expect a problem with them running append queries. It's editing the same record where they would clash, though it shouldn't corrupt anything, just prevent the second user from saving their changes. Corruption commonly comes from letting multiple people share the same copy of the application.

[ChobeyGuddu]

Thanks Paul (Pbaldy)
Thanks ranman256