Back end security

[Rose B]

I have an application with the FE and BE split, and the BE resides on a
network server. The user access is controlled through the FE application -
but is there any way of ensuring that nobody (albeit accidentally)
deletes/updates the BE tables directly i.e. going into them directly not via
the FE?

 

[Joan Wild]

A simple solution is to put an autoexec macro in the backend:

Msgbox - "Access denied. Use the frontend"
Quit

This would run if the BE was opened directly. You could also disable
the shiftkey bypass in the backend so the autoexec macro isn't bypassed.
You could also put the backend in a hidden folder, so it's not so easy
for users to find
\\share\folder$ rather than \\share\folder

All these techniques will keep the honest/curious out which may suit
your needs.

Joan Wild