Prevent direct access to the back-end Ms Access database

I have this problem, I can create a setup for my app/database but everyone开发者_JAVA技巧 can open the backend file which is an MS Access database. I want it so we can only access the database using the frontend app. Please help me ...

You will need to create a separate front end app that accesses the database, and keep the database file somewhere secure where direct access to it is limited/restricted. You should also password-protect the file in case someone does manage to get it See tip #10 here: https://web.archive.org/web/1/http://blogs.techrepublic%2ecom%2ecom/10things/?p=552 for info about password protection (though you might find the other tips useful as well).

Whatever you do, don't rely on Access password protection. It can be cracked in minutes by tools freely available on the internet.

I would get Garry Robinson's book Real World Microsoft Access Database Protection and Security

It is the most comprehensive guide to securing an Access database that there is.

A first step, however, would be to put the backend file in a restricted folder.