I've created a password protected Access 2000 database then split it so I've got the forms, reports and code in a front end database and the data tables are in the back end database. However, it is now possible to open the back end database without a password and access the data. I tried adding a password to the back end database (the same password as the front end database) but when the front end database tries to open the back end tables it fails because the back end is password protected.
Would anyone know how I can have the front end database pass the appropriate password to the back end database?
Would anyone know how I can have the front end database pass the appropriate password to the back end database?