By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,571 Members | 3,168 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,571 IT Pros & Developers. It's quick & easy.

default work group file not available

P: 1
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
May 4 '10 #1

✓ answered by 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)>

Share this Question
Share on Google+
1 Reply


missinglinq
Expert 2.5K+
P: 3,532
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)>
May 4 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.