Multiuser problem

[jbkirby via AccessMonster.com]

I try to split my database into its backend and front-end. When I'm done, I
tried to test whether a query would work on each workstations and it worked
successfully. Apparently, when I tried to run a query on the front-end on 2
workstations at the same time, I got this error message on 1 of the
workstations.
"Could not use "\\185-73038\testing$\Reference.mdb; file already in use"

Please someone help me resolve this issue. Thank you.

 

[Douglas J. Steele]

What permissions have you given each user for the folder in which the
back-end MDB file exists \185-73038\testing$\Reference.mdb ?

They need at least Create, Read and Write permission (and usually should
have Delete permission as well).

 

[jbkirby via AccessMonster.com]

some users have read access only. I'm just curious, they can run a query if
they are executed individually in their workstations. But upon simultaneous
execution, that is where the problem comes.

What permissions have you given each user for the folder in which the
back-end MDB file exists \185-73038\testing$\Reference.mdb ?

They need at least Create, Read and Write permission (and usually should
have Delete permission as well).

I try to split my database into its backend and front-end. When I'm done, I
tried to test whether a query would work on each workstations and it

[quoted text clipped - 6 lines]

Please someone help me resolve this issue. Thank you.

 

[Douglas J. Steele]

You will run into problems if some people have read-only access to the
folder.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

some users have read access only. I'm just curious, they can run a query
if
they are executed individually in their workstations. But upon
simultaneous
execution, that is where the problem comes.

What permissions have you given each user for the folder in which the
back-end MDB file exists \185-73038\testing$\Reference.mdb ?

They need at least Create, Read and Write permission (and usually should
have Delete permission as well).

I try to split my database into its backend and front-end. When I'm done,
I
tried to test whether a query would work on each workstations and it

[quoted text clipped - 6 lines]

Please someone help me resolve this issue. Thank you.

 

[jbkirby via AccessMonster.com]

Aha. I gave them write access and it is working fine now. Thanks sir.

You will run into problems if some people have read-only access to the
folder.

some users have read access only. I'm just curious, they can run a query
if

[quoted text clipped - 14 lines]