Please excuse me if this is very basic, but I have just upgraded to Office
2003 and now every time I open a specific pre-existing database it asks me
for a username and password. I haven't set a password, so all i have to do is
click OK (it remembers the username I last entered). But it's a bore having
to do that and I can't find any way of turning this "nag" off. I get lost
when I try to understand the user level security wizard...

Can anybody help a newbie?

Many thanks

===Toby Wallis===

"Toby Wallis" <(E-Mail Removed)> wrote in message
news6CFBB6E-1F78-408F-B0F5-(E-Mail Removed)...
> Please excuse me if this is very basic, but I have just upgraded to Office
> 2003 and now every time I open a specific pre-existing database it asks me
> for a username and password. I haven't set a password, so all i have to do
> is
> click OK (it remembers the username I last entered). But it's a bore
> having
> to do that and I can't find any way of turning this "nag" off. I get lost
> when I try to understand the user level security wizard...
>
Upgrading to Office 2k3 shouldn't cause this to happen.

Open the workgroup administrator from the Tools ... Security menu. If the
file referenced is not "System.mdw" then you need to browse to it and join
it using the "Join..." button (it'll be somewhere on the drive where Office
is installed - if you're on a corporate network then it may be in your
profile).

If the file references *is* "System.mdw" (on your local drive) then someone
has modified it. Close Access, delete "System.mdw". Access should create a
new "clean" one the next time you open it.

Hopefully that will sort your problem.

Regards,
Keith.
www.keithwilby.com

Thanks, Keith. Deleting security.mdw did it.

===Toby===

"Keith" wrote:

> "Toby Wallis" <(E-Mail Removed)> wrote in message
> news6CFBB6E-1F78-408F-B0F5-(E-Mail Removed)...
> > Please excuse me if this is very basic, but I have just upgraded to Office
> > 2003 and now every time I open a specific pre-existing database it asks me
> > for a username and password. I haven't set a password, so all i have to do
> > is
> > click OK (it remembers the username I last entered). But it's a bore
> > having
> > to do that and I can't find any way of turning this "nag" off. I get lost
> > when I try to understand the user level security wizard...
> >
> Upgrading to Office 2k3 shouldn't cause this to happen.
>
> Open the workgroup administrator from the Tools ... Security menu. If the
> file referenced is not "System.mdw" then you need to browse to it and join
> it using the "Join..." button (it'll be somewhere on the drive where Office
> is installed - if you're on a corporate network then it may be in your
> profile).
>
> If the file references *is* "System.mdw" (on your local drive) then someone
> has modified it. Close Access, delete "System.mdw". Access should create a
> new "clean" one the next time you open it.
>
> Hopefully that will sort your problem.
>
> Regards,
> Keith.
> www.keithwilby.com
>
>
>