Re: Securing database with the wizard

"ExDeltamech" <ExDeltamech@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:58188CF6-32D4-49DB-B751-F519774E2BB8@xxxxxxxxxxxxxxxx
>I just secured my first database on a network using the wizard, everything
> works fine except when I try to open a new database it asks for user name and
> password. Is there anyway to de-activate this without losing my user-level
> security on my secure database? When I open an unsecured database I don't
> want to have to log on to it.

There are two ways to stop the prompting. You can remove the password from the
Admin user. Of course doing this will cause all attempts to open the file to do
so AS the Admin user so you won't be able to get in unless you grant rights to
the Admin user in which case your file is no longer secured.

Better is to create a shortcut that you use for opening this particular file.
In that shortcut you can specify your secure workgroup file (this allows you to
leave your default as System.mdw), as well as the account name and password that
you normally use. Then the file will open without a prompt.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



.

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 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)
  • 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: Word 2007 Missing User Level Securitty - ARRRGGGGHHHH What were they thinking?
    ... File servers aren't secure? ... Access predates Windows security, ... database system has never been updated or kept current. ... the OS-based database server product, ...
    (microsoft.public.access.security)
  • Re: security wizard cannot be run
    ... You need to open your database using your secured mdw (i.e. the desktop ... Open Access (not via the shortcut). ... Create a new mdb and import everything from your 'secure' mdb. ... Once the database opens, the ...
    (microsoft.public.access.security)
Loading