We have a client database that is used by Microsoft access. We would really like for our receptionists to have Internet access so we can use things such as online scheduling etc. but we are concerned about the security of our client list. We're not so much concerned about someone hacking our database because we have software for protection. We are just looking for a way to make sure our list cannot be uploaded or emailed and sold. But the files do need to be able to be overwritten and modified. I understand that this boils down to employee trust but whatever. Any ideas?
It depends on what server-side scripting language you use to make database calls to Microsoft Access. If you are using something like PHP there are numerous encryption options built in that are safe. I recommend http/stackoverflow.com as it has a lot of questions related to encryption and such stuff. http/serverfault.com is also great, but just a heads up that if you ask a question that's already been asked you'll be downvoted a lot.
But it really depends on your server configuration, you need to hash the values before writing them to the database.