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?

 

[PaulO]

How would they even know there's a split database, and where to find the _BE file? Unless you've told them?

You should perhaps, in any case:-

1) Disable the Database Window at Startup
2) make sure the FE is menu/form driven
3) Hide the Table objects
4) Even better perhaps, issue the Database in a RUNTIME environment and take MS Access off the User Workstations (unless they need it for other database applications)