User-Level Security Wizard

[Guest]

Hello,

In Access 2003, whenever I use the User-Level Security Wizard on a database,
and I re-open it, it locks me out completely and doesn't ask me for a
password. What am I doing wrong, or is there something within the Wizard
which doesn't work?

I want to have some users who have read/write access to all areas, and some
users who have read-only access to all areas.

I am completely new to this aspect of Access, please don't assume any level
of competence!!

Many thanks,

Franc.

 

[Scott McDaniel]

Hello,

In Access 2003, whenever I use the User-Level Security Wizard on a database,
and I re-open it, it locks me out completely and doesn't ask me for a
password. What am I doing wrong, or is there something within the Wizard
which doesn't work?

Normally the wizard will create a desktop shortcut to use when opening your secured database. It appears you're
attempting to open the database directly - this will get you a "YOu don't have permissions blah blah" error and you
won't be able to get into the database.

If the wizard didn't create a shortcut you can build one yourself. Add a desktop shortcut, then set the Target to this:

"full path to msaccess.exe" "full path to your db" /wrkgrp "full path to your workgroup file"

I'd also STRONGLY encourage you read and understand ULS before implementing it. ULS is a tricky and complex subject and
has tripped up more than one developer.

Here's Jack MacDonald's excellent writeup on ULS:

http://www.geocities.com/jacksonmacd/

This site also includes links to other sites, including the MS User Level Security FAQ, which is also required reading.

I want to have some users who have read/write access to all areas, and some
users who have read-only access to all areas.

I am completely new to this aspect of Access, please don't assume any level
of competence!!

Many thanks,

Franc.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Guest]

Thanks for that Scott.
I'll get reading!
Franc.

Normally the wizard will create a desktop shortcut to use when opening your secured database. It appears you're
attempting to open the database directly - this will get you a "YOu don't have permissions blah blah" error and you
won't be able to get into the database.

If the wizard didn't create a shortcut you can build one yourself. Add a desktop shortcut, then set the Target to this:

"full path to msaccess.exe" "full path to your db" /wrkgrp "full path to your workgroup file"

I'd also STRONGLY encourage you read and understand ULS before implementing it. ULS is a tricky and complex subject and
has tripped up more than one developer.

Here's Jack MacDonald's excellent writeup on ULS:

http://www.geocities.com/jacksonmacd/

This site also includes links to other sites, including the MS User Level Security FAQ, which is also required reading.


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com