How do I undo security in ms access?

[Guest]

I chose user-level security on the db I created. Now I cant open even a new
db as it's prompting me for password which I didn't remember inputting. My
colleagues can still access the db in our lan so I guess it could be my lan
id. I supplied my lan id and pssword but it wont open. How do i gain my
access back?

 

[Keith Wilby]

I chose user-level security on the db I created. Now I cant open even a
new
db as it's prompting me for password which I didn't remember inputting.
My
colleagues can still access the db in our lan so I guess it could be my
lan
id. I supplied my lan id and pssword but it wont open. How do i gain my
access back?

See my reply to the post by JaB.

Keith.
www.keithwilby.com

 

[Guest]

thanks for the reply keith.
but these are my problems:
1. i can't even open my ms access in the network
2. how to rejoin the system.mdw

 

[Keith Wilby]

thanks for the reply keith.
but these are my problems:
1. i can't even open my ms access in the network

Not sure what you mean - do you get any error messages?

2. how to rejoin the system.mdw

Select Tools, Security, Workgroup Manager and browse to "system.mdw"
(usually in c:\Documents and Settings\<profile name>\Application
Data\Microsoft\Access).

Keith.

 

[Guest]

Keith, when i clicked on my ms access it's straight away prompting me for a
user name and a password. it's happening even when i try to open a new db or
want to access other databases i have.

 

[Guest]

another question: can i just delete the system.mdw and reinstall ms access?

 

[Keith Wilby]

Keith, when i clicked on my ms access it's straight away prompting me for
a
user name and a password. it's happening even when i try to open a new db
or
want to access other databases i have.

That's because you're joined to your custom workgroup file. Rejoin the
default "system.mdw" using the workgroup administrator. If you've modified
"system.mdw" then rename it, Access will create a new one if it can't find
it.

Keith.