User level security problem in Access 2000

[lskuff]

Hi,
I am developing a database for an organization and they recently requested me to implement a user level security system. I have run the User Level Security wizard and I set up the different groups and created usernames and passwords for the diffent group users. When I enter an invalid password at the password prompt and I enter an invalid user name or password it asks to enter it again. But when I log on as anyone except the administrator account then I get the error: Run-time error '-2147217843 (80040e4d)': Not a valid account name or password.

I can hit end and open forms and stuff but I don't know why this error keeps popping up. Can anyone help me?

And it h

 

[lamarw]

Hi,
This is a little womething I found on the internet. It may addreess your issue. Let me know if it helps:

I think you missed, providing the DB password, use the following as your connection string here following are the variables:
<DBPath> and <DBPwd>...

code:------------------------------------------------------
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & DBPath & ";Jet OLEDBatabase Password=" & DBPwd
-----------------------------------------------------------

This would enable you to connect to the password protected MS Access database.

 

[lskuff]

Where would I put that? In a module in my database?