Suscribing. Sounds like something I may do later. How secure is this? The data I deal with is confidential.
Security and MS Access is an oxymoron in and of itself although even using a secure database is only going to provide that security for the database and not the information traveling across the net. Most information transfered across the net is all sent in plain text, there are many ways of encrypting this information and every step you take in order to secure the information is one more step a hacker has to take if he/she is going to try and hack into it, usually this will eliminate a lot of the hackers and if done properly will knock out most of them.
I have managed a few web servers and I can say that hackers were constantly knocking and if you have access to the server then you know the steps that are taken on that end, which is really important also.
If you are truly serious about data security and such don't put it on the web, or just realize that there is a potential for a hacker to access it. It happens to many major corporations all the time I am sure you have read about many such breaches although I believe there are many breaches that go on that they would rather us not know about.
There are hackers sitting there waiting for the next hole in a platform and as soon as it is exposed you have to be faster than them to rectify it.