disable password functionality

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Long time ago, I set the password for opening a database file. I actually
forgot how I enabled the password functionality. Now I want to disable this
functionality. I went to tools | security, but I couldn't find what I want.

please help. Thanks!
 
Simply remove the password from the admin user, and all prompts will go
away.

If you plan or need security for just ONE database..then use a separate
workgroup file (mdw) for that file..so ONLY that file gets a log on
prompt...
 
I went to tools->security->unset database password. But it pops up a dialog
box saying I couldnt do it.

U mean went to tools->security->user and groups accounts to delete Admin? it
pops up a dialog box saying I couldnt do it.also.

any ideas? thanks!!
 
I went to tools->security->unset database password. But it pops up a dialog
box saying I couldnt do it.
Click to expand...

The database password has NOTHING to do with the users workgroup security
settings.
U mean went to tools->security->user and groups accounts to delete Admin? it
pops up a dialog box saying I couldnt do it.also.
Click to expand...

You can't delete the account since you are logged on as admin! When you run
ms-access, the default user is ALWAYS admin (in fact, since the default user
is admin..that you CAN NOT delete this user. (of couse, then when you run
ms-access..what user would it use?).

So, you don't want to delete the admin user..but you simply want to clear
the password for the admin user.
 
Matt said:
I went to tools->security->unset database password. But it pops up a dialog
box saying I couldnt do it.
Click to expand...

If you are trying to unset a database password, you need exclusive access to
the mdb to do that. File, Open, and then choose Open Exclusively in the
lower right of the open dialog. You should then be able to unset the
password via Tools, Security, Database Password.

If that doesn't work, post back with the error that comes up.
 
Back
Top