Linking back end db to mdw file

[Caddie]

Hi All -

I secured my database with the wizard a few days ago then I split the db. The permission and logins were working for both the front and back end perfectly, but when I tried to open an access file that wasn't supposed to be protected it was asking me for a password. So I accessed the workgroup administrator through VBA immediate and entered a command (I found online) to rejoin to the default MDW file. Now I can access my unprotected files without being asked for a password, and when I logon to my protected db through the front end it asks me for my password (perfect) BUT now when I open my backend DB I'm not prompted for a password, so I can only assume that the backend DB is not pointed to the new (protected) MDW file. How do I fix this so when I open the backend DB it asks me for my password? (Points to the new MDW file)

 

[ghudson]

A database does not point to a mdw. Your backend is not correctly secured. I find it easier to create a database and secure it the way I want, then I split it by make a copy of the database [name each accordingly, front end and back end] and remove the ojects I do not want in the front end and back end and link the tables from the front end to the back end.

You have to use a custom shortcut and set the target value to define the location of the database and the location of the mdw file that the secured database needs to be able to open it.