Re: security only works on my PC

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.


.

Relevant Pages

  • Re: Adding new users to an Access 2002 DB
    ... So the mdb opens when you are using the standard system.mdw. ... It sounds like someone didn't secure it properly, ... When you open it, go to Tools, Security, permissions and check to see what ...
    (microsoft.public.access.security)
  • Re: Security logins and such
    ... If you want to secure your mdb, you need to create a new workgroup file. ... Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: How to prevent theft of BOTH secured Access database AND .mdw file
    ... > You still have to crack the password if the database is secured, ... If someone steals the mdb without the workgroup file, ... from making a copy of BOTH the secure Access DB ...
    (microsoft.public.access.security)
  • RE: Access to Access Automatic Updates
    ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... MS Office Master 2000 ed. ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)
  • RE: Access to Access Automatic Updates
    ... MS Office Master 2000 ed. ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)
Loading