default work group file not available

[vazeer]

hi!
i configured User Level Security with option new file configuring to specific database and it working fine on a specific database but when i am try to open another database it astound me that it is asking login n password to access i use all user which i created for the above database but it is wont work or open and my default file also not in the default location like c:\Documents and Settings\<%UserName%>\Application Data\Microsoft\Access\System.MDW

please give me your suggestion to open the another database without login dialog box...

thank you

[missinglinq]

To be honest, some of the wording of your post is rather confusing, but the bottom line here is that when you set up User Level Security in Access you're not setting security for an individual database but rather for the Access application on that particular computer, and as you've found out, it applies to all databases run on that machine.

Conversely, setting up security on your development machine won't apply if you copy the database to another computer unless you set up security on that one as well.

The only workaround to this is to "roll your own" security, which can be a daunting task, deopending on your programming skills/experience.

Welcome to Bytes!

Linq ;0)>