Access password

  • Thread starter Thread starter Clinton
  • Start date Start date
C

Clinton

I have written a program which uses an Access database. The program accesses
the database using the Admin account and allows the user to set a database
password. This all works fine, but I know the day will come when the user
forgets the password! Is there a way of setting a backdoor account or am I
going about this the wrong way?

Thanks
Clinton
 
Do not use the Admin account for your users.
Set a password which YOU know (and remember).

Now create another account for your users -
don't give it "administer" rights to the database.
If a user comes to you with a forgotten password, you can go into the
database,delete the account with the forgotten password, and create a new
account as desired.

Clearly, there wouldn't be a lot of point in enforcing security if there's a
back-door to find out passwords.

HTH
- Turtle
 
I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.
 
Thanks. I'll have a look.

Clinton

Joseph Meehan said:
I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Clinton said:
I have written a program which uses an Access database. The program accesses
the database using the Admin account and allows the user to set a database
password. This all works fine, but I know the day will come when the user
forgets the password! Is there a way of setting a backdoor account or am I
going about this the wrong way?

Thanks
Clinton
Click to expand...
Click to expand...
 
Back
Top