User leve security question

  • Thread starter Thread starter TADropik
  • Start date Start date
T

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?
 
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
 
TADropik said:
I'm trying to apply User level Security for a specific .MDB in Access
2003.
(not all .mdb's)

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

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.
Click to expand...

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?
Click to expand...

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
 
Back
Top