How do I undo security in ms access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
purple said:
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?
Click to expand...

See my reply to the post by JaB.

Keith.
www.keithwilby.com
 
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
 
purple said:
thanks for the reply keith.
but these are my problems:
1. i can't even open my ms access in the network
Click to expand...

Not sure what you mean - do you get any error messages?
2. how to rejoin the system.mdw
Click to expand...

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

Keith.
 
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.
 
purple said:
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.
Click to expand...

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.
 
Back
Top