Solved

Prompted for workgroup security logon when creating new database

Posted on 2008-10-17
3
236 Views
Last Modified: 2010-04-21
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
Comment
Question by:shambalad
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 22742437
<<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
 
LVL 7

Author Comment

by:shambalad
ID: 22743630
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
 
LVL 7

Author Closing Comment

by:shambalad
ID: 31507193
Sometimes I can't see the forest for the tree. Thanks for the help.
Todd
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now