Thanks for the tip it worked like a charm!
"Keith Wilby" wrote:
[Quoted Text] > "kakweer" <kakweer[ at ]discussions.microsoft.com> wrote in message
> news:BB49F4C5-18D2-4B38-8A1B-7F0E280F2536[ at ]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
>
>
>
|