workgroup information file & passwords

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
kakweer said:
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.
Click to expand...

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
 
Thanks for the tip it worked like a charm!


Keith Wilby said:
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
Click to expand...
 
Back
Top