Problem Using Access Security Key in Multiuser enviroment

  • Thread starter Thread starter Vince
  • Start date Start date
V

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
 
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"
 
Back
Top