<div>
Superb - this should do the trick nicely.<br />
<br />
Thanks as always - have a great weekend.
</div>


Superb - this should do the trick nicely.

Thanks as always - have a great weekend.

<div>
<div class="content wysiwyg-content">
I have an Access 2003 database that is split (front / back-end). &nbsp;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. &nbsp;However, I still need to be able to go into it and make my changes (plus setup the link for the front-end).<br />
<br />
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.<br />
<br />
I do appreciate that you can't completely secure an Access database, but I just need a little more control.<br />

</div>
</div>


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.


Securing a back-end mdb file

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.