Access 2007 Database Backend Security

[bakkouz]

Hi,


I have an Access 2007 dbase that is split into a front-end/back-end configuration.
My back-end file is stored on the file server, and front-end file is stored on the user's computers.
Thus, the back-end file is linked to the front-end file via a network share, ie: //fileserver/data/program/db_be.accdb

This could create a problem, since users need read/write access on the folder to be able to store data on the back-end file, some could access the network share and directly open the back-end file and mess with the data, naturally, I don't want that to happen>

So, How can i protect the back-end db file from being accessed directly by a snoopy user? and make the data only accessible through the front-end file?

[pdebaets]

One method is to encrypt your back-end database: http://office.microsoft.com/en-us/ac...010096299.aspx

[bakkouz]

pdebaets:
This is magnificent,
thanks