Encrypt data in SQL Server

[DeMoN]

Hi.

I'm developing a VBA application with SQL Server.

I need to encrypt data from client machine to server, but I have no idea how
to do it.

Any help will be grateful

Regards.

 

[Steve Jorgensen]

The only obvious way I can think of is to have client machines connect to the
SQL Server using an encrypted VPN connection, then connect to SQL Server using
the server's VPN adapter IP address.