chouetteray said:
I created a database on my local drive and secured it using the
wizard. I then placed a copy/shortcut on a different drive.
Copy/shortcut of what? Did you copy the WIF to a network location that all
users have permissions to? Did you copy the MDB to a network location that
all users have permissions to? Did you copy the shortcut the wizard created
to each user's PC?
No one
can open it but me. They all get an error message that they don't
have permission... How do I change the current WIF to point to the
new drive and not my local drive? Thanks a million.
Copying the shortcut to each user's PC will work, provided they have Access
installed in the same location as you do on your computer.
The shortcut should look like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"
You can use UNC pathnames for the mdb and mdw
(\\server\share\ rather than some mapped drive letter).
If you get the above working, you should split the database and leave the
backend (tables/relationships) on the server. Give each user a copy of the
frontend (all other objects with linked tables pointing to the backend on
the server) on their PC. Then modify the "path to mdb" portion of the
shortcut to point to the local copy of the frontend.mdb.
When you split it, don't use the splitter wizard as that will result in an
unsecure backend mdb. Instead split it manually.
