when two users try to access the same table it will not allow changes to store

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patrick B - 12 Jul 2005 13:56 GMT

I have Microsoft office 2003
I'm new at this - I copied my database to the network. I want to have
multiusers to be able to enter data into the database. From what I've read it
is possible as long as they are not trying to open the same record in the
table.
But, even if each user is in a different record, prompt says record will not
be saved.
Each of us has Access 2003 on our PC.

Do I need any add on software in addition to Access 2003. I've never tried to
set up a multi user system before -- I'm a rookie.

Signature

Pat

Reply to this Message

Alex Dybenko - 12 Jul 2005 16:16 GMT

Hi,
normally this should work fine, try to set record-level option in options
dialog

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

>I have Microsoft office 2003
> I'm new at this - I copied my database to the network. I want to have
[quoted text clipped - 10 lines]
> to
> set up a multi user system before -- I'm a rookie.

Reply to this Message

Patrick B - 27 Jul 2005 16:39 GMT

Thanks,
I finally split the database and it seems to be working fine now.
Thanks
Pat

>Hi,
>normally this should work fine, try to set record-level option in options
[quoted text clipped - 5 lines]
>> to
>> set up a multi user system before -- I'm a rookie.

Signature

Pat

Reply to this Message