Securing an Access database

[FancyPrairie]

I've been developing an Access database with SQL as the back-end. But have run into a problem with security. Although I can encrypt the SQL back-end, how do I encrypt the data as it is transmitted across the network between the Access front-end and the SQL back-end?

I need to ensure that if someone is monitoring network traffic, they can't interpret my data because it is encrypted.

 

[jrbarnett]

This is more a SQL server question than Access, but something like:

https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx

John