Securing a back-end mdb file
Posted on 2011-02-25
I have an Access 2003 database that is split (front / back-end). I would like to be able to secure the back-end to stop certain people being able to link to the tables (via Excel etc), or open it through Access. However, I still need to be able to go into it and make my changes (plus setup the link for the front-end).
I am not using an mdw file (and if possible would like to stay away from it), but I could just do with a few pointers.
I do appreciate that you can't completely secure an Access database, but I just need a little more control.