Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

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
0
shambalad
Asked:
shambalad
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now