Multiple users problem

[shmoussa]

Hi. I hope someone can help me.

I have my database stored on a shared network drive. I have created 3
user names, two of which have passwords (User1 and User2). The other
user (User3) does not have a password because they only have read-only
access.

When I open the database from the computer which I secured it from, I
get a login prompt, which is good. When I open it from any of the
computers connected to my large network, the login prompt is not there
and the database just opens with full permissions. I need full
permissions set for two users and read-only set for one user. I've
gone through the wizard, as well as the manual settings and everything
appears to be filled in correctly.

The network consists of over 50 computers, with different Windows
login names. Does this have ANYTHING to do with Access permissions?
How can I get a login prompt to pop-up regardless of which computer/
Windows username I am logged into?

I would appreciate any help you can offer.

 

[Lynn Trapp]

The best way to do this is to create a shortcut for each of your users that
points to the appropriate .mdw file. The general syntax for this is:

FullPathToMSAccess.exe FullPathToDatabase.mdb /wrkgrp FullPathToSecurity.mdw

 

[shmoussa]

Thank you for your reply. Please don't mind my lack of knowledge in
this area, but I'm not sure exactly what you mean. I tried making a
new shortuct and when asked for the path, am I to type: "C:\Program
Files\Microsoft Office\Office\MSACCESS.exe M:\Disk Utilization 2.0.mdb/
wrkgrp M:\Secured.mdw"?? Could you be a little bit more specific and
let me know what I should try. Thanks so much!!

 

[Lynn Trapp]

Your quotation marks need to go around each of the individual parts of the
target.

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe:" "M:\Disk
Utilization 2.0.mdb" /wrkgrp "M:\Secured.mdw"

 

[shmoussa]

Thank you for your response. That did work for the shortcut file I
created. Whenever, and wherever I open the shortcut, I get the login
prompt. However, when I open the actual database, which is available
to anyone, there is still no login prompt. How can I embed the login
prompt into the actual database? It only opens the login prompt from
my workstation and that's it. I need it to open everywhere, without
using a shortcut. Please help. Thanks again.

 

[Joan Wild]

Hey stranger, where've you been?

 

[Lynn Trapp]

hehehe... working my hiney off but, hopefully that will change. Have you
seen my message in the Private group?

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com



Hey stranger, where've you been?

 

[Lynn Trapp]

If you have the individual users join the secure workgroup, using the
workgroup administrator, then that will work for you.

 

['69 Camaro]

Hi.

user (User3) does not have a password because they only have read-only
access.

This is a security risk. Without a password, _anyone_ can use User3's User
ID to get in and look at the data. Are you fine with that?

When I open it from any of the
computers connected to my large network, the login prompt is not there
and the database just opens with full permissions.

Then the database is not secured. Either you missed a step (or a few), or
else you used Access 2000's Security Wizard, which has some flaws and
doesn't secure a database file properly. Please see the following Web page
for the Security FAQ, which gives step-by-step instructions on how to
implement User-Level Security:

http://support.microsoft.com/?id=207793

Study it and practice a few times on a copy of your database before
implementing it on the production version.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Joan Wild]

hehehe... working my hiney off but, hopefully that will change. Have you
seen my message in the Private group?

No, I was run off - I'll email you.

 

[shmoussa]

Okay I just realized the problem but don't know how to fix it...at my
workstation, after running the user/security wizard, ANY MS Access
database that I open prompts a logon dialog box, even unsecured ones.
I don't want this. I want just my certain Access file to popup a logon
box, regardless of which workstation it is being opened from. How can
I fix my problem, and make this do what I want it to do. ? Thank you.

 

[Lynn Trapp]

Then you have to use the shortcut method that I described to you earlier.

 

[shmoussa]

Thanks for your reply but, I just cleared the password from the Admin
user and now all other Access files are back to normal. However, I
trying to use FAQ from Microsoft's site to do this manually. It tells
me to use Wrkgadm.exe to create a new workgroup information file. How
do I get to this? I tried putting Wrkgadm.exe in the Start---
RUN....but doesn't work. Any help?

 

[Lynn Trapp]

Which version of Access are you using?

 

[shmoussa]

I am using access 2000. I tried the Microsoft FAQ and followed step by
step. However, even if I create a new workgroup file, when I apply a
password to the Admin account (so that a login dialog will come up) it
only works on my computer, and worse yet, it brings a login dialog box
anytime I want to open a different database.

I need it to:

1.) Not affect any other databases but this certain one, which is
stored on a shared network drive so that other computers can access
it.
2.) Bring up a login box, for this certain database only, regardless
of which computer it is opened from. I don't want a login dialog box
everytime I open another database. For this database only, I want the
login box- anywhere it opened.
3.) 2 administrators, and one user who can only view information and
not change it.


Any more guidance would be appreciated.

 

[Joan Wild]

I am using access 2000. I tried the Microsoft FAQ and followed step by
step. However, even if I create a new workgroup file, when I apply a
password to the Admin account (so that a login dialog will come up) it
only works on my computer, and worse yet, it brings a login dialog box
anytime I want to open a different database.

Every session of Access uses a mdw file. When you create a new one, Access made it the default one to use for all sessions. That is why you are getting the login dialog for every database. Use the workgroup administrator to join to the system.mdw that ships with access as your default. Then create a desktop shortcut to start your secure mdb. The target of the shortcut would look like:
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

Using this shortcut will override the default mdw and use your secure mdw for just that session of Access.

I need it to:

1.) Not affect any other databases but this certain one, which is
stored on a shared network drive so that other computers can access
it.
2.) Bring up a login box, for this certain database only, regardless
of which computer it is opened from. I don't want a login dialog box
everytime I open another database. For this database only, I want the
login box- anywhere it opened.
3.) 2 administrators, and one user who can only view information and
not change it.

You need to follow the steps exactly, and not miss anything, nor do things out of order. I have outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

Once you have it secured properly, you won't be able to open it unless you use the correct secure mdw file.

 

[shmoussa]

Thank you so much. I believe this did it. I will test it out on other
machines later on today and will let you know if I have a problem.
Thank you so much for your help.