RE: Able to open secured database with default MDW

Hi Susan,

You missed a step somewhere.

Are you sure you were joined to your secure mdw when you added the user?
You may have still be joined to system.mdw.


--
Joan Wild
Microsoft Access MVP


"Susan L" wrote:

I've searched the newsgroups on this topic and have come up with answers that
I have already addressed. The problem is that I am able to open my "secured"
file when using the default System.mdw. (I'm using Access 2003) Plus, I
followed Joan Wild's and Lynn Trapps instructions closely. Maybe there's
something I've overlooked?
1) Created custom workgroup file, with a custom admin user, "sradmin."
2) Logged on as SR admin & created password.
3) Logged on again as sradmin and created blank database into which I
imported all objects.
4) Verified that sradmin owns all objects including the database itself.
5) Verified that the Users group has no privileges.
6) Moved the Admin user to the Users group.
7) Created shortcut for opening the secured database.

When I set up security before (Access 2000), whenever I double clicked the
database icon, I received a "no privileges" message. The only way to get in
was to use the shortcut. I originally thought it might be my copy of Access
at work, but the same thing is happening on my home computer (Access 2003).
Any suggestions?
--
susan
.

Relevant Pages

  • Re: is it possible to make a database secure after creating it as unsecure?
    ... can I make it secure completely then? ... assigned as the database owner, and all of the original owner's permissions ... Since the default Admin user still has permissions in the database, ... Security to secure your database, because anyone who really wants to break ...
    (microsoft.public.access.formscoding)
  • RE: security wizard cannot be run
    ... Using the secure mdw a password is requested. ... blank the database can be opened. ... for the Admin user. ...
    (microsoft.public.access.security)
  • Re: Securing database with the wizard
    ... >I just secured my first database on a network using the wizard, ... so AS the Admin user so you won't be able to get in unless you grant rights to ... In that shortcut you can specify your secure workgroup file (this allows you to ... I don't check the Email account attached ...
    (microsoft.public.access.security)
  • Re: Always asked to login, and I cant!
    ... This is known as a "secure" workgroup. ... The default Admin user most definitely has a password, ... if you want to open or create a database file. ...
    (microsoft.public.access.security)
  • Re: Security not clicking
    ... looked good until I copied the secured database to the network. ... Joan Wild wrote: ... When I rejoin the system mdw, ... split the database when it is secure or when it is not secure? ...
    (microsoft.public.access.security)