Protect Back-End Access database using password

Question

I'm using a database divided:

• front-end: contains forms, reports, etc etc;

• back-end: it contains tables;

Now I need to protect the back-end with a simple password.

NOTE: The password must be only on the back end. The front-end must be free access.

Thanks. Best regards.

Answer 1

To protect by password a divided access database is necessary:

1. delete links to the tables from the database front-end;
2. open back-end Database in exclusive mode;
3. insert password;
4. re-link table into front-end database.

this video can help to understand: Protect divided Access database

Answer 2

You really could bing/google on this yourself. Anyway, here's a round-up where #8 covers the password:

10 tips for securing a Microsoft Access database