Inicial user in a data base with Access 2003

A

António Madeira

Hi!

By default when Access 2003 open a database, de user is set to
Administrator. In the security opcions we can create other users, but the
database allways open with Administrator user.
I want to open a database with another username (not Administrator - by
default). How can I do that?

Tanks
 
R

Rick B

Adding users to a Workgroup does NOT secure the database. Anyone can open
the database as administrator (because you did not bother to take away
access from the Administrator). You could simply add a password to the
administrator account which will force the pop-up when the databse is
opened, but a smart Access user would simply use their default workgroup and
sign on with their Admin userId.

The only way to fix this is to properly secure your database.

You need to make a backup of your database and then read (and reread) the
various instructions on implementing user-level security. This is NOT an
easy process, but you must complete ALL the steps IN ORDER if you wish to
secure your database.

Read the following links and secure your database.

--
Rick B

Security FAQ

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



The Security Whitepaper is also worth reading to help you understand.

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



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm
 
Top