workgroup information file & passwords

[kakweer]

While trying to set different user level options for a new database, using
the security wizard in 2003, I inadvertantly locked the database and was only
able to access it from my PC. After reading through all the posts that seemed
relevant I managed to bypass the problem by using the "path to msaccess.exe"
"path to mdb" /wrkgrp "path to secure mdw" shortcut solution. However, I need
to deliver this to my client and they will be setting it up on their LAN. So,
I want to get rid of the admin user password that pops up when I open the
database. Tried deleting Security.mdw but that was less than successful
(hence the shorcut solution). PLEASE help.

 

[Keith Wilby]

While trying to set different user level options for a new database, using
the security wizard in 2003, I inadvertantly locked the database and was
only
able to access it from my PC. After reading through all the posts that
seemed
relevant I managed to bypass the problem by using the "path to
msaccess.exe"
"path to mdb" /wrkgrp "path to secure mdw" shortcut solution. However, I
need
to deliver this to my client and they will be setting it up on their LAN.
So,
I want to get rid of the admin user password that pops up when I open the
database. Tried deleting Security.mdw but that was less than successful
(hence the shorcut solution). PLEASE help.

Open your db using the admin account. Grant full permissions for all
objects (including the database object) to the "Users" group. Close the
app, open a new blank app and import all of the objects from the first app.
This assumes you don't want user-level security to be set up of course.

Regards,
Keith.
www.keithwilby.com

 

[kakweer]

Thanks for the tip it worked like a charm!

Open your db using the admin account. Grant full permissions for all
objects (including the database object) to the "Users" group. Close the
app, open a new blank app and import all of the objects from the first app.
This assumes you don't want user-level security to be set up of course.

Regards,
Keith.
www.keithwilby.com