Prompted for workgroup security logon when creating new database

I am trying to create a new database with no workgroup security. My problem is whenever I try to create the database, I am prompted to logon using workgroup security. If I click Cancel, the database is not created.
I tried re-booting and then trying to create the database, but that didnt work.
How can stop this from happening?
Thanks,
Todd
LVL 7
shambaladAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<How can stop this from happening?>>

Access workgroup security is always "on" and cannot be turned off. Normally you don't see a login because the default workgroup file has a user account called "admin" with a blank password. This is the first login that JET tries when opening a database and if it suceeds, you don't get a login. If it doesn't, it pops up the login dialog.

So it's either one of two things:

1. The password for the admin user is a non-blank.

2. Your joined to the wrong workgroup.

Have you recently worked with user level security or done anything that may have started this?

JimD.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shambaladAuthor Commented:
I work with numerous databases and numerous workgroups here. Basically, as you suggest, I need to be using a workgroup that has the admin profile set with its default permissions and a blank password. In my case, the default workgroup that Access first creates fit the bill.

e.g.: "C:\Documents and Settings\< My Profile >\Application Data\Microsoft\Access\System.mdw"

There are two solutions that I have found that work. One is to simply logon using the current default workgroup when prompted. Then after the database starts, joining the workgoup I really wanted to be part of when working with the database.

There is a second way to do this that bypasses having to log on to the current default workgroup, when creating a new database. This is done by going into the Registry and changing the value of the default workgroup that Access uses when it starts up.

Registry Key:
My Computer\HKEY_CURRENT USER\Microsoft\Office\11.0\Access\Jet\4.0\Engines\SystemDB
0
shambaladAuthor Commented:
Sometimes I can't see the forest for the tree. Thanks for the help.
Todd
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.