Web Based or Access Front End

[AccessNewbie]

I have been told that my database will be more secure if I go to a web based
design rather than the current Access front end I use. I have never been
given specific reasons only the assurance that I need to move to web based
design. Any concrete evidence either way? To me the users are unaware of
which front end is being used.... Thanks!

 

[Rick Brandt]

I have been told that my database will be more secure if I go to a
web based design rather than the current Access front end I use. I
have never been given specific reasons only the assurance that I need
to move to web based design. Any concrete evidence either way? To me
the users are unaware of which front end is being used.... Thanks!

Since security is all about the "back end" a web front end can be made more
secure because the user has no direct access to the back end. They only get
whatever data your web service sends them. For an Access front end to work
the user must have actual file-level access to the back end which means they
can copy it, alter it, delete it, etc..

One can also get more security by using a server back end (which would let
you keep your Access front end). The reason is similar. The user does not
need to have access to the actual files containing the data. Instead the
server back end sends only the data that your Access front end asks for.