Password Protect Backend

[JimmieC]

I have an Access 2000 split into FE and BE and the client has requested the BE be password protected. I attempt set database password on BE but then when I open FE I get error msg " not a valid password". I get the same error message if FE has same password or if FE has no password.
Any ideas?

Thanks,

Jim

 

[trucktime]

Protect

You can put a form in the BE with a password protected Command Button that either opens the Database Window or closes Access.

Ofcourse you have to hide the Database Window when Access opens.
In addition you can hide/unhide the toolbars.

 

[geralf]

You have to delete all the table links in the FE, then re-link again to the BE. You'll be asked to enter the password once, After closing the FE and re-open it again, you won't be asked for the password again.

 

[JimmieC]

Thanks

Thanks for the help, it worked just as you said.

Regards,

Jim