How Do I Remove Security

[Bob Sanderson]

I set up a password protected Access Database and would like to now
completely remove the password and any security functions. How do I do
this?

Any help will be greatly appreciated.

[Keith W]

"Bob Sanderson" <sa*****@LUVSPAMsandmansoftware.com> wrote in message
news:Xn**********************************@207.69.1 89.191...

I set up a password protected Access Database and would like to now
completely remove the password and any security functions. How do I do
this?

Any help will be greatly appreciated.

Grant full permissions to all objects for the "users" group.

HTH - Keith.
www.keithwilby.com

[Bob Sanderson]

"Keith W" <he**@there.com> wrote in news:43********@glkas0286.greenlnk.net:

"Bob Sanderson" <sa*****@LUVSPAMsandmansoftware.com> wrote in message
news:Xn**********************************@207.69.1 89.191...

I set up a password protected Access Database and would like to now
completely remove the password and any security functions. How do I do
this?

Any help will be greatly appreciated.

Grant full permissions to all objects for the "users" group.

I don't think I described the situation correctly. I created a .mdw file
and would like to convert it to a mdb. Is that possible?

[Steve]

According to the big bot Google, .MDW files are Access Workgroup
information files. This means you cannot convert a .mdw to a .mdb
because the MDW file does not hold your database information. All it
has is definitions for your workgroups and users. Theoretically, you
may be able to at least get into your database by either deleting your
..mdw file or replacing it with another. However, your objects your
Access database probably have associations to specific groups or users
(for ownership identification), so your best bed is probably to just
get a password recovery tool. Google has a bunch of results for "access
password recovery mdw" (~29,000).

[Br]

Bob Sanderson wrote:

"Keith W" <he**@there.com> wrote in
news:43********@glkas0286.greenlnk.net:

"Bob Sanderson" <sa*****@LUVSPAMsandmansoftware.com> wrote in message
news:Xn**********************************@207.69.1 89.191...

I set up a password protected Access Database and would like to now
completely remove the password and any security functions. How do I
do this?

Any help will be greatly appreciated.

Grant full permissions to all objects for the "users" group.

I don't think I described the situation correctly. I created a .mdw
file and would like to convert it to a mdb. Is that possible?

That doesn't make sense:) The MDB is your database, wheras the MDW is
the workgroup (security) file that holds only user information (not
data, forms etc or permissions).

As mentioned above, to remove the security you must log in using your
secured workgroup as a valid user, give the Users group permissions to
everything. Then go back to the default Access workgroup, create a new
database and import your old database.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response