Setting Database Password: Errors

[stever]

I am attempting to add a password to a database -- meaning
when the db is opened the user is prompted to enter in the
appropriate password.

I have done this on many db's and it has worked fine. For
some reason, over the last month or so, I keep getting an
error when I attempt to add the password. Here is what I
am doing.

a.Creating a new db and giving it a name.
b.Closing this new db
c.Opening it again, and selecting "Open Exclusive"
d.Select Tools>Security>Set Db Password
e.Entering the password and confirming the password
f. I receive an error message saying that I must have the
db open as the exclusive user. I do have it open as the
exclusive user but for some reason Access is not
recognizing this.

Do I need to work with the User and Group permissions
first, and then set the password for some reason?

 

[Tim Ferguson]

d.Select Tools>Security>Set Db Password

A quick scan of the internet will reveal a large number of tools or
services to break simple password locking of a database. In most people's
view, it's not worth the effort as a method of security.

Do I need to work with the User and Group permissions
first, and then set the password for some reason?

This is not proof against a really determined attack, but will stave off
even most power-users. The catch is that you (as the developer) do have to
know what you are doing, so lots of practice and lots of backups are in
order!

B Wishes


Tim F

 

[stever]

Thanks for the reply -- I have the pword in place to
prevent someone from accidently deleting the db or opening
it up and making a change to it.

I may have missed this in your reply -- Do you know why I
am getting the error and why I am unable to establish the
password?? Thanks.

 

[Tim Ferguson]

I have the pword in place to
prevent someone from accidently deleting the db

Huh? The only way to do this is by manipulating the ReadOnly flag or Folder
access permissions.

Do you know why I
am getting the error and why I am unable to establish the
password??

Errmmm: no! I was just suggesting that it's not a very good solution
anyway.

B Wishes


Tim F

 

['69 Camaro]

Hi.

f. I receive an error message saying that I must have the
db open as the exclusive user. I do have it open as the
exclusive user but for some reason Access is not
recognizing this.

If you've already applied user-level security to the workgroup that you are
currently joined to, then your user must have Open Exclusive permissions to
open the database exclusively. If
Access cannot open the database exclusively, then one does not receive an
error message, but the file is opened in shared mode, instead.

If you haven't applied user-level security to the workgroup, then check to
ensure that neither a locking database file nor a workgroup information file
already exist in the same directory as the database file, and whose base
file name matches the database file name. For example, if the database file
name is MyDB.MDB, then the locking database file name would be MyDB.LDB, and
the matching workgroup information file would be named MyDB.MDW. If another
user is joined to the workgroup information file, it would create or modify
the locking database file, preventing you from opening the database file
exclusively.

Do I need to work with the User and Group permissions
first, and then set the password for some reason?

No. User-level security is separate from shared-level security. One type
does not require the presence of the other.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)