Simultaneous Insert

[swapna_munukoti]

Hi all,

I was trying to insert few records(approximately 1000) into access
DB from two different machines simultaneously using insert query. I am
using Begin and commit transaction. After every 100 insert statements,
I am displaying a message box.
I started the application in one machine first and waited at the
message box after executing 100 insert statements. And then started the
application in another machine. The application in another machine got
hanged till the transaction in the 1st machine is completed.
It didn't even throw an error. Can anyone explain me why did it
happen.
I want to know if MS-Access allows multiusers to insert the records
to same table simultaneously. If not, then is there a way to achieve
this?

Thanks,
Swapna.

[Rich P]

If two users are trying to write to the same Access table, then yes,
they will have to wait turns. But even if two users were trying to
write to 2 separate tables in the same DB at the same time, I don't
think Access supports that since it is a File based system as opposed to
a service based system like sql Server. With Sql server two users wouls
also have to wait turns to write to the same table, but two users can
write to 2 separate tables at the same time.
Rich

*** Sent via Developersdex http://www.developersdex.com ***