Remove security / password

[Stephen Green]

While experimenting with the security settings, I seem to have password
protected my database. (I DO know the password!) However, I'd like to
remove ALL security from this database at the moment. I don't want to be
prompted for UserName / password on opening the database.
How can I do this?

Thanks for your help.

Stephen

 

[Stephen Green]

Well, somehow I really screwed up. I can't get into the database at all!!!
It tells me I haven't got the permissions necessary. It doesn't ask for a
password...

Can anyone help???

Stephen

 

[Stephen Green]

I seem to have gotten some control back. I can open the database now. I'd
still like to know how to remove all security. I have two files in the
folder with the mdb - security.ldb and security.mdw. What do these files
do??

Sorry for the dumb questions...

Stephen

 

[Tom Wickerath]

Hi Stephen,

The .ldb file is a locking database file. See the following KB article for more information:

Introduction to .ldb files
http://support.microsoft.com/?id=299373

Your security questions should be answered by reading the following document. The information in
this document also applies to Access 2002 and 2003:

Microsoft Access Security FAQ Available in Download Center
http://support.microsoft.com/?id=207793


Tom
______________________________________

I seem to have gotten some control back. I can open the database now. I'd
still like to know how to remove all security. I have two files in the
folder with the mdb - security.ldb and security.mdw. What do these files
do??

Sorry for the dumb questions...

Stephen

 

[Charlie]

I seem to have gotten some control back. I can open the database now. I'd
still like to know how to remove all security. I have two files in the
folder with the mdb - security.ldb and security.mdw. What do these files
do??

Sorry for the dumb questions...

Stephen

I don't know if my situation is equivalent, but when I had a password
protected database, I simply made a copy of it (while accessing it
with the correct password) to aonther database, and did not protect
that new database.

Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

 

[Van T. Dinh]

Check Access Help topic: "Remove user-level security".

HTH
Van T. Dinh
MVP (Access)

 

[Stephen Green]

Thanks all. After lots of wailing, rending of clothes and pulling of hair,
I figured it out...

Stephen