User level security problem

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

Guest

For one of my access file I implemented ULS. Now when ever I open up other
access files it is bringing up the log in box. None of my other files have
any ULS associated with them. Can anyone tell me why this is happening and
how I can have the log in box come up for just that one file?
Thanks
Tim
 
TC said:
For one of my access file I implemented ULS. Now when ever I open up
other access files it is bringing up the log in box. None of my other
files have any ULS associated with them. Can anyone tell me why this
is happening and how I can have the log in box come up for just that
one file?
Thanks
Tim
Click to expand...

Prompting for a login has NOTHING to do with the file you intend to open.
It is entirely controlled by the workgroup file being used. If you open
Access with a workgroup file that has a password on the Admnin user account
then you are prompted. If you use a workgroup file that has no password on
the Admin account then you are not prompted.

When you secured your file you created a new workgroup file that has a
password on the Admin account and you made that workgroup file your default.
Therefore, you are always prompted.

If you do not want to be prompted all the time then change your default
workgroup back to System.mdw. That of course *should* mean that you won't
be able to open your secured file unless you open it with a shortcut that
specifies a workgroup file other than your default. Try it though after
changing your default. You might find that your secured file still opens
which will mean that you didn't apply security properly.
 
Rick
Thank you when I changed it back to teh system.mdw the login in prompt
stopped coming up. Is there a way for me to have a workgroup that applies
only to that one access file and for the rest it will use the system.mdw file?
Tim
 
TC said:
Rick
Thank you when I changed it back to teh system.mdw the login in prompt
stopped coming up. Is there a way for me to have a workgroup that
applies only to that one access file and for the rest it will use the
system.mdw file? Tim
Click to expand...

As I indicated before you can create a shortcut that launches Access and
(for that session only) specifies a workgroup besides your default. The same
shortcut can specify which file Access should open as well. The complete
target would be...

"Path to MSAccess.exe" /wrkgrp "path to secure MDW" "path to MDB"

Don't think of workgroups as "applying to certain MDB files". It doesn't
work that way. A workgroup doesn't care what file you might open and an MDB
doesn't really care what workgroup is being used per-se.

The workgroup logs you in silently as Admin if Admin has no password and
prompts you for a login when Admin does have a password. When you are
prompted all that the workgroup cares about is that you give it credentials
that it recognizes.

The MDB is only concerned with what group IDs and user IDs have permissions
to do stuff. It doesn't care which workgroup file provides that
information. Only that the information that is provided satisfies required
permissions. It just so happens that in most cases there is exactly one
workgroup file that contains IDs that the MDB "likes", but that is
coincidental and not always the case.
 
Back
Top