I double clicked it and I get a warning "unknown publisher do you want
to open this db" . I get rid of the warning and it brings up the user
level security dialog with login and password. I noticed in the
security you can set a database password so I set one assuming there
wasn't one. I double clicked the closed db and I get a security again
"warning unknown publisher" . I would like to get rid of it. Then up
came the user level security "first". I give it the user login and pw
and the system password dialog comes up "second" which seems to be the
reverse of what you said unless the warning message is canceling out
the double click and it thinks it is a single click which might be the
case. I can't change anything in security because it says you have to
be in exclusive mode. The split front end and back end have made
something more complicated than it needs to be. I just want to run
the script to compact the backend. If there was no system password it
would be better to leave it blank. This database is in a secure
location so I don't need one if there isn't one but maybe I can try
your test again once I get rid of the unknown publisher dialog.
I have another problem. I use a shortcut to open the back end. The
dialog comes up for login user level and the backend is open. Then I
open the front end in exclusive mode and it says "not a valid
password" so I need to get rid of the system password I just set in
the backend. I think that is why I can't open the front end at all
now. I was having another problem before this opening the front end.
When I did open the front end in exclusive mode it came up without the
design mode. It came up with forms and I couldn't edit the front end
even when I held the shift key down? Please help get me out of this.
thanks,
The database password and user password for Access user level security aren't
interchangeable.
How do you tell *which* one you need?
Database password:
1 - double click to open the db. You're prompted with this: "Password
Required" and "Enter database password". Notice it says "database password".
Notice there's only one text box to type in the database password, not two
text boxes (for the user name and personal password). You can't mistake this
for any other password because it says "database password" in the prompt.
2 - type the database password. If Access lets you in, you have the right
password.
Access user level security:
1 - double click to open the db. You're prompted with this: "Logon", and 2
text boxes, 1 for the name and 1 for the password. Notice it doesn't say
"database password". Notice it gives 2 text boxes, 1 for the user name and 1
for the user's password. You can't mistake this for the database password
because it doesn't ask for the database password and it requires 2 bits of
info: user name and user's password. No individual user has his/herown
database password. Everybody shares the same database password so you don't
need to identify a name to also go with the database password. Having 2 text
boxes to fill in is your clue Access isn't asking for the database password,
but for the user name and user's password.
2 - type the user name (if it's not already showing) and user's password. If
Access lets you in, you have the right user name and user's password.
So is that clear? If you need to type the database password, Access asks for
the database password. If you need to login with user level security, Access
asks for user name (which is often filled in for you) and the user's password.
Chris
This is a split front end and back end database. The backend is on Z
drive. I have a short cut that brings up the login.