Why is this so hard?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

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

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

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