Secure communications in MS Access to SQL
Posted on 2011-09-06
I need to create a database system for a large organisation and will be using MS Access.
My thoughts are to use MS Access Front End and MSSQL server back end. This I have done with linked tables and as database projects.
My question is... I need to ensure the communications between MS Access and MS SQL server are secure.
If I use ODBC then they are NOT so much.. If I use Database Projects then again...unsure of exactly how secure this is.
Can I have recommendations using these technologies please what would others approaches be to keep sensitive information securely or encrypted communications or whatever.