Security will not work on other computers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I set the security on my database on my computer so now when i open the database it prompts me to login but when i go to another computer and open the file, it doesn't prompt me to login in, it just logs me on as admin. when i go into my database and take the permission away from admin and then go on to another person's computer it gives me an message saying i don't have permission to open the database but it doesn't give me a login screen. what am i doing wrong? please help!
 
Sounds like the other user is not logging in with the correct mdw
(workgroup) file.

Depeding on how you secured your file, you should have had a shortcut
created for you by the wizard. That shortcut will not only open the file,
but will also open the correct workgroup.

The userIDs and passwords live in the workgroup file.

Rick B


I set the security on my database on my computer so now when i open the
database it prompts me to login but when i go to another computer and open
the file, it doesn't prompt me to login in, it just logs me on as admin.
when i go into my database and take the permission away from admin and then
go on to another person's computer it gives me an message saying i don't
have permission to open the database but it doesn't give me a login screen.
what am i doing wrong? please help!
 
Candy said:
I set the security on my database on my computer so now when i open the
database it prompts me to login but when i go to another computer and open the
file, it doesn't prompt me to login in, it just logs me on as admin. when i go
into my database and take the permission away from admin and then go on to
another person's computer it gives me an message saying i don't have permission
to open the database but it doesn't give me a login screen. what am i doing
wrong? please help!

Getting a logon prompt is NOT dictated by the file you're opening. It's
dictated by the workgroup file being used. On your machine you have changed
your default workgroup to one that requires a logon. The same thing has not
occurred on the other users PCs so they don't get one.

Rather than changing those other user's default workgroup to the one you created
when you secured the file, it is better to make it available on the LAN and then
give all users a shortcut that specifies the workgroup file as a command line
argument. That way they aren't prompted for logons for other files that don't
require it. The shortcut target line would look similar to...

"path to MSAccess.exe" /wrkgrp "path to workgroup file" "path to mdb file"
 
Candy said:
How and where do I create the shortcut target line?

Find the MSACCESS.EXE file on your computer. When found right-click and
drag it to your desktop. You will be given some choices when you release
the right mouse button. One of those will be "Create Shortcut Here". You
now have a shortcut to the Access executable on your desktop. Right-click
on that and choose properties. You can then modify the target line to
include the...

/wrkgrp "path to workgroup file" "path to mdb file"

....at the end of the existing target.

To test the shortcut use the Workgroup Administrator Utility to change your
default workgroup file back to System.MDW. You should then find that if
you open Access normally and attempt to open your file that you are not
prompted for a logon and are denied access. Then you can close Access and
double-click your new shortcut. You should get a prompt this time and you
should be able to open the file providing you supply valid account
information.

Now, if your other users have Access installed in the same folder you do,
you simply make copies of your new shortcut for them to use. If some have
Office in a different location you will need to make modifications to the
target property accordingly.
 
Candy said:
my msaccess.exe is on my c: drive which is my local drive and my mdw
and mdb files are on a shared drive L: this is what i put as my
shortcut and it doesn't work. what am i doing wrong?

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"/"L:\Contact
List\MS Access Database Contact List\Security.mdw""L:\Contact List\MS
Access Database Contact List\GAIN_ContactList.mdb"

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp
"L:\Contact
List\MS Access Database Contact List\Security.mdw" "L:\Contact List\MS
Access Database Contact List\GAIN_ContactList.mdb"

You left out the wrkgrp and you were missing some spaces.

In addition you can use UNC pathnames rather than relying on the mapped
drive letter.
 
Rick Brandt said:
database it prompts me to login but when i go to another computer and open the
file, it doesn't prompt me to login in, it just logs me on as admin. when i go
into my database and take the permission away from admin and then go on to
another person's computer it gives me an message saying i don't have permission
to open the database but it doesn't give me a login screen. what am i doing
wrong? please help!

Getting a logon prompt is NOT dictated by the file you're opening. It's
dictated by the workgroup file being used. On your machine you have changed
your default workgroup to one that requires a logon. The same thing has not
occurred on the other users PCs so they don't get one.

Rather than changing those other user's default workgroup to the one you created
when you secured the file, it is better to make it available on the LAN and then
give all users a shortcut that specifies the workgroup file as a command line
argument. That way they aren't prompted for logons for other files that don't
require it. The shortcut target line would look similar to...

"path to MSAccess.exe" /wrkgrp "path to workgroup file" "path to mdb file"
 
Back
Top