User-Level Security Wizard

[Techtrainer]

I have a database I am trying to run the User-Level Security Wizard on and it
keeps giving me an error "An unexpected error error occured while creating
the workgroup file. : The wizard can't complete successfully.

I admit I am not up on security administraion. I am prepping for a class and
within the workgroup information file I am trying to create, through the
wizard, I want to set it up to include a Read-Only Users group, and create
one user (from within the wizard so I can allocate a password) to be a part
of this group. Now I am totally lost because the system gives me no login box
when the database is opened and won't let me recreate the workgroup
information file. I also tried to create the user using the User and Group
Accounts operation, but saw no provisions for assigning a password to the new
user. I also tried deleting the .mdw file in one of my previous attempts, to
start from scratch, but then I could not even open the database file. If
someone could just point me in the right direction, I would be grateful.

 

[Roger Carlson]

Have you downloaded and read through the Security FAQ?
http://support.microsoft.com/kb/207793/en-us

 

['69 Camaro]

Hi.

I have a database I am trying to run the User-Level Security Wizard on and
it
keeps giving me an error "An unexpected error error occured while creating
the workgroup file. : The wizard can't complete successfully.

Do you have Windows read/write security permissions on the directory where
the workgroup information file is to be saved? Do you have Windows
read/write security permissions on the directories where the Access wizards
are located (which often depends upon the operating system and version of
Access you are using)? Do you have Windows read security permissions on the
common libraries that Access uses? Is each registered in the Windows
Registry for the path where it exists?

Now I am totally lost because the system gives me no login box
when the database is opened

It will prompt for the User ID and password if and only if you are joined to
a workgroup where the default Admin user has a password set, or else you are
using a Windows shortcut that joins you to such a workgroup for the current
session only.

I also tried to create the user using the User and Group
Accounts operation, but saw no provisions for assigning a password to the
new
user.

You can do it with VBA code, but if you want to restrict yourself to just
the GUI, then once the default Admin user for that workgroup has a password,
and you've joined that workgroup, sign in using that user's User ID with no
password. Once the database opens, select the Tools -> Security -> User and
Group Accounts... menu. Select the "Change Logon Password" tab and provide
the new password. (The old password is, of course, still blank.)

I also tried deleting the .mdw file in one of my previous attempts, to
start from scratch, but then I could not even open the database file.

I hope you have a backup of that file or can recreate it with the same names
and PID's used in the original workgroup file. Otherwise, you're not
getting into the secure database file without spending quite a few bucks.

If
someone could just point me in the right direction, I would be grateful.

Roger provided a link to the official Security FAQ. Read it in its entirety
before attempting to implement security to keep from shooting yourself in
the foot.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Joan Wild]

I will just add to the other responses....
If you look in the folder where your mdb is location, you'll likely find a file with the same name, but a bak extension.

This is a backup of your unsecured mdb. Restore it (rename it to have a mdb extension); delete the mdw file you created using the wizard.

Backup your mdb, and try again.