Muti User Access Problem

[George]

I asked this earlier and it was suggested to make sure I have the proper
folder permissions set for the folder - Read Write Execute - I did and it
didn't fix it.

I loaded my database on our LAN system at work and only one
person at a time can open it. When the program is in use I looked inside
the folder we share I see the program's icon and another icon of the program
with a locked symbol on it. Once they close the program the extra icon with
the
lock symbol disappears and the next person can then open the database.
What can I do to correct this ?

Thanks

 

[Jeff Boyce]

George

When this happened to me, the LAN gurus had "accidentally" removed the users
read/write permissions from the folder holding the back-end. Please
re-verify that all the folks who need to use the application have these
permissions on the entire folder and all files.

The other potential cause is the application being opened for EXCLUSIVE use.
That would mean the first user in locks out all others.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

What can I do to correct this ?

Be sure that the default open mode is shared, not exclusive; give everyone
read/write/create/delete privileges to the folder containing the database; and
be sure that you're not using the /excl command line switch in any shortcut
which is being used to open the database.

John W. Vinson [MVP]

 

[George]

John - When you say Make sure the default open mode is shared - is this a
folder setting on the LAN or a setting inside the Access database ?

Thanks

 

[George]

Thanks Jeff / John

Will try your suggestions tomorrow.

George

 

[John W. Vinson]

John - When you say Make sure the default open mode is shared - is this a
folder setting on the LAN or a setting inside the Access database ?

The latter: Tools... Options... Advanced... radio button in the box labeled
Default Open Mode.

John W. Vinson [MVP]