Home All Groups Group Topic Archive Search About
Author
26 Sep 2008 11:33 AM
johankotze via AccessMonster.com
I have a problem!!
I have 3 computers on my network, one is the server and the other two
computers are linked to the server where my Back End database is installed
the Front End Database is installed on the other two computers.

When one operator is busy working on form ClientInformation the other
operator can't work on the same form ClientInformation. The message that I
get is the following.

"Could not lock table ClientInformation; currently in use by user Admin on
machine Notebook Johan"

I want multiple users to work at the same time on the same tables & forms.
How can I fix this.

--
Message posted via http://www.accessmonster.com

Author
26 Sep 2008 2:07 PM
Joan Wild
All users need read/write/create permissions on the folder where the backend
is located.

--
Joan Wild
Microsoft Access MVP
"johankotze via AccessMonster.com" <u46323@uwe> wrote in message
news:8ac45f697a5b0@uwe...
Show quoteHide quote
>I have a problem!!
> I have 3 computers on my network, one is the server and the other two
> computers are linked to the server where my Back End database is installed
> the Front End Database is installed on the other two computers.
>
> When one operator is busy working on form ClientInformation the other
> operator can't work on the same form ClientInformation. The message that I
> get is the following.
>
> "Could not lock table ClientInformation; currently in use by user Admin on
> machine Notebook Johan"
>
> I want multiple users to work at the same time on the same tables & forms.
> How can I fix this.
>
> --
> Message posted via http://www.accessmonster.com
>
Author
28 Sep 2008 1:03 PM
johankotze via AccessMonster.com
Hi Joan how do I set it.

Joan Wild wrote:
Show quoteHide quote
>All users need read/write/create permissions on the folder where the backend
>is located.
>
>>I have a problem!!
>> I have 3 computers on my network, one is the server and the other two
>[quoted text clipped - 10 lines]
>> I want multiple users to work at the same time on the same tables & forms.
>> How can I fix this.

Author
28 Sep 2008 4:46 PM
Joan Wild
Right-click the folder, choose properties, security tab - you'd need to be
logged into the computer with an admin account.

--
Joan Wild
Microsoft Access MVP
"johankotze via AccessMonster.com" <u46323@uwe> wrote in message
news:8ade4c152a595@uwe...
Show quoteHide quote
> Hi Joan how do I set it.
>
> Joan Wild wrote:
>>All users need read/write/create permissions on the folder where the
>>backend
>>is located.
>>
>>>I have a problem!!
>>> I have 3 computers on my network, one is the server and the other two
>>[quoted text clipped - 10 lines]
>>> I want multiple users to work at the same time on the same tables &
>>> forms.
>>> How can I fix this.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200809/1
>