MS Access 2010 security when accessing SQL Server online
Posted on 2014-04-15
I built an Access 2010 front-end application that connects via ODBC linked tables to MS SQL Server which is hosted online. My customer is happy with the database in general but has become concerned with a perceived risk from hackers that might be able to grab/sniff his login credentials to the SQL Server while using this database on public wifi networks, etc.
What are my options for making this database configuration more secure? I have researched this online some, but I'm not coming away with anything that I really understand.