MS Access Multiuser - Simultanious Insert.

Author

Simultanious Insert.

swapna_munukoti@yahoo.co.in

2005-08-08, 9:24 am

Hi all,

I was trying to insert few records(approximatel
y 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.

Larry Linson

2005-08-08, 8:26 pm

This question was answered in the newsgroup microsoft.public.access.

Please do not multipost (as you did here, that is, post identical messages
separately to different newsgroups); if you are really worried that you need
to post to more than one to get an answer, crosspost to all at once, so all
will have all newsgroups in the header, and answers will automatically go to
all the newsgroups you used. For other good suggestions on effective use of
newsgroups, see the FAQ at http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP

< swapna_munukoti@yaho
o.co.in> wrote in message
news:1123507851.243152.11680@g47g2000cwa.googlegroups.com...
> Hi all,
>
> I was trying to insert few records(approximatel
y 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.
>

Sponsored Links