User leve security question

[TADropik]

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?

 

[Tom van Stiphout]

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

 

[Keith Wilby]

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