By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,659 Members | 1,750 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,659 IT Pros & Developers. It's quick & easy.

How Do I Remove Security

P: n/a
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.
Nov 14 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"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
Nov 14 '05 #2

P: n/a
"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?
Nov 14 '05 #3

P: n/a
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).

Nov 14 '05 #4

P: n/a
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
Nov 14 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.