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 <(E-Mail Removed)> 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


>
>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?

"TADropik" <(E-Mail Removed)> wrote in message
news:959834B5-2D18-4964-B4B0-(E-Mail Removed)...
>
> 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.

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

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

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

>
> 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?

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