Re: security only works on my PC
- From: brem219 <brem219@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 7 Nov 2006 07:04:02 -0800
Joan, thank you for your reply. This was my first time using security, so
please bear with me.
You need to use the
workgroup administrator to rejoin the system.mdw workgroup file that ships
with Access.
I don't know what this means. I opened the workgroup administrator but only
saw the new workgroup I created when I added security. If there's another
one, where do I find it?
Then use a desktop shortcut to launch your secure mdb The
target would be
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"
I don't know how to do a shortcut. Do I just right click on my desktop and
type in exactly what you wrote?
I want my the 6 users to be able to open the database. The database is
configured so that users will be able to access the tables through a series
of queries, but not look at or change the tables. I'm not sure about
changing the permissions. I've adjusted the permissions on my PC so that 2
of the 6 users have admin priveleges, and the ability to look at tables and
change the database.
"Joan Wild" wrote:
Sounds like you only partially implemented security..
On your PC, likely the default workgroup file is set to the one you created
to secure the mdb with. Therefore you are prompted for a login (by the way
you will get this prompt, no matter what mdb you open). You need to use the
workgroup administrator to rejoin the system.mdw workgroup file that ships
with Access. Then use a desktop shortcut to launch your secure mdb The
target would be
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"
You users are able to open the mdb, but then can't open any tables. That
suggests that the Users Group has permission to Open/Run the Database.
These users are using the standard system.mdw to open the database, and
therefore they are being silently logged in as Admin, a member of the Users
Group.
Use your shortcut to open the database, and go to Tools, Security,
Permissions. Choose the Users Group, and verify that there are no
permissions to any object for this group. You might also want to check that
the 'Admin' user is not the owner of any objects.
If you follow every step in securing the mdb, users should not even be able
to open the mdb.
Once you have it secured properly, you'll want to put the secure mdw on the
server, and give each user a shortcut to open the mdb.
--
Joan Wild
Microsoft Access MVP
brem219 wrote:
I created a database with security for a team of 6 users. It worked
fine with each user on my computer. However, when I move it to the
network, it doesn't ask anyone for their name and/or password. It
just opens to the first screen, and then when they try to look at
their work, it gives them an error message, saying they can't access
the tables. I want it so that each user can login from their own PC
and look at their work. I would prefer to accomplish this without
giving everyone Admin priveleges.
Thanks for your help.
- Follow-Ups:
- Re: security only works on my PC
- From: Joan Wild
- Re: security only works on my PC
- References:
- Re: security only works on my PC
- From: Joan Wild
- Re: security only works on my PC
- Prev by Date: Re: security only works on my PC
- Next by Date: Re: security only works on my PC
- Previous by thread: Re: security only works on my PC
- Next by thread: Re: security only works on my PC
- Index(es):
Relevant Pages
|
Loading
