"kakweer" <kakw***@discussions.microsoft.com> wrote in message
news:BB49F4C5-18D2-4B38-8A1B-7F0E280F2536@microsoft.com...
> 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" wrote:

> "kakweer" <kakw***@discussions.microsoft.com> wrote in message
> news:BB49F4C5-18D2-4B38-8A1B-7F0E280F2536@microsoft.com...
> > 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
>
>
>