Problem Using Access Security Key in Multiuser enviroment

[Vince]

Hi,

I have created an application with Access with linked
tables stored on the network. Each user will recieve the
application on their desktops (More computing power and
less loading).

I have created a CORPORATE.mdw key and want new users to
join the workgroup located on the server
G:\Accesskey\corporate.mdw (they all have access to this
path)

I did it successfully BUT, when testing it loggin in the
first user and then the second user I noticed it gave an
error message... regarding corporate.mdw key is currently
in use....

What is wrong and how can I do this so that I don't need
to store the key in each workstation.

What am I doing wrong?

I noticed this works fine on another database I created
with only 4 users so I just left the DB and Key on
another network folder and running the entire DB (tables
and all) directly via a shortcut on each of the four
users desktop....

Please advise,

Thanks,
Vince

 

[Joan Wild]

Users need full permissions on the folder where the mdw is.

Also you don't need to have users join the corporate.mdw as their default.
Give them a desktop shortcut that launches the mdb and uses the appropriate
mdw. Also you can use UNC pathnames and not have to rely that users have
the folder mapped to G:

"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

 

[Vince]

Thanks Joan...I put a new post with other problems....

Vince