How do you password protect back end databases in MS Access 2007?
Posted on 2010-11-20
I was given a database that has a front end (forms, tables, code, etc) and two back ends (tables, passwords,respectively).
I need to password protect the two back ends. If I link the front end to back end tables and then password protect the back ends (open exclusive and set passwords), I get an incorrect password message when I try to open the tables from the front end. How can I set passwords in the back ends so that the back end tables can be opened via the front end?