Beginner's Question - Security

[Toby Wallis]

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===

 

[Keith]

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

 

[Toby Wallis]

Thanks, Keith. Deleting security.mdw did it.

===Toby===