Why is this so hard?

[natalie]

I am still having trouble getting this security thing. I have read some good
posts and links and followed instructions (so I think) but still this is
giving me problems.

When I secured one database, now every time I open up any other database I
still have to log in. I find that very annoying. Furthermore, I still don't
understand how to put the secure shortcut on the users' computers. I am
running out of time to get this completed so any and all help will be much
obliged!

 

[Lynn Trapp]

When I secured one database, now every time I open up any other database I

still have to log in. I find that very annoying.

Natalie,
I think you are making this harder than it really is. The reason you are
prompted for a login with all databases is that you are joined to the same
workgroup information file that the database is secured with. You want to be
joined to the system.mdw that shipped with Access and use the shortcut
described below for your secure database.

Furthermore, I still don't
understand how to put the secure shortcut on the users' computers. I am
running out of time to get this completed so any and all help will be much
obliged!

The target for the shortcut needs to be "FullPathToMSAccess.exe"
"FullPathToYourDatabase.mdb" /wrkgrp "FullPathToSecure.mdw" You can create
on for you and email it to all your users or, else, go to their computer
and create in manually.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[natalie]

Lynn,
You have been very helpful so far, thank you. But I must be really stupid,
because I still don't comprehend the whole thing. After reading what you
posted below, I opened up Access (not a database) and under
tools/security/workgroup administrator I switched the path back to the
default - and voila! I am not prompted for a login.
However, now the database that I secured says I don't have permissions when
I try to open it and it won't let me in.
Also, the targets you said I need for the shortcut - the
"fullpathtomsaccess.exe" etc - that isn't actually what it is supposed to
say, right? It's supposed to be whatever path I give it? I'm really not
that bright. I'm regretting getting suckered into this project for my
company.

 

[Lynn Trapp]

You have been very helpful so far, thank you. But I must be really

stupid,
because I still don't comprehend the whole thing. After reading what you
posted below, I opened up Access (not a database) and under
tools/security/workgroup administrator I switched the path back to the
default - and voila! I am not prompted for a login.

Good. First Step down.

Also, the targets you said I need for the shortcut - the
"fullpathtomsaccess.exe" etc - that isn't actually what it is supposed to
say, right? It's supposed to be whatever path I give it? I'm really not
that bright. I'm regretting getting suckered into this project for my
company.

No, you should change that to the actual path. On my computer it would be:
"C:\Program Files\Microsoft Office\OFFICE11.MSAccess.exe" There's a pretty
fair possibility that yours is the same, but you need to verify that.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[natalie]

Hi, Lynn. Sorry to bother you again, but since I changed the workgroup admin
path to the default c: drive, now the secured database won't let me in. It
says I don't have permissions - so how then do I open it up to change its
specific path?

 

[Lynn Trapp]

Hi Natalie,

You don't have to open the database to make any changes. You just have to
create a desktop shortcut that will use the target that I described to you.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Joan Wild]

You don't do this from within the mdb file. Try this.
Start, Find, Files and Folders
msaccess.exe
is the name of the file you are looking for. Click on Find. Once it finds
it, right-click on it, choose Send To...Desktop as shortcut.
Go to your desktop, and you'll see the newly created shortcut.
Right-Click it and choose rename, and give it meaningful name.
Right-click it again and choose, properties.
It will open and show you the 'path to msaccess.exe' in the target line.
Now all you need to do is edit that (click at the end) and add the rest of
what Lynn specified
"path to mdb" /wrkgrp "path to secure mdw"