I'm trying to apply User level Security for a specific .MDB in Access 2003.
(not all .mdb's)

I created C:\Security.mdw
I edited my systems registry setting and everything works great.

However I have many .mdb's that now prompt for my user name and password at
start up.

Is there a way I can set it up so only the .mdb I'm trying to secure prompts
for a User name at start up and not the others?

On Tue, 7 Jul 2009 10:09:03 -0700, TADropik <t**@sportmutt.com> wrote:

You are in dangerous territory. Where in the Access Security Faq that
you downloaded, studied, and fully understood before starting this
task did you read you had to edit the registry?

ULS is an advanced topic. Treat it as such.

-Tom.
Microsoft Access MVP


Show quoteHide quote

I'm not sure you did and if you did it was completely unnessary and, as
noted by Tom, probably dangerous.

That's because you're joined to you custom workgroup and the behaviour is
normal.

Re-join your unmodified "system.mdw" workgroup.  Join your custom workgroup
on a session-by-session basis using the "/wrkgrp" switch in a shortcut.

I suspect you haven't read the FAQ, there's a link to it on my web site.

Keith.
www.keithwilby.co.uk

FE Security for Linked Tables & purpose of Shortcut
Automation & Command line arguments
trusted location on network
User security advice
How can I switch the current user from the default (Admin)?
Help with Security
Wireless clients can't aquire ip address
changing security level in access 2002
Lockdown!
clone group, then rename?