We have a Foxpro 8 database on our local machine and a shared sql server database on our remote machine. We have created a remove view that updates or inserts data into the sql server db using the local foxpro data.

What is the recommended way to secure these updates or inserts? We're worried that since our data is not encrypted, it is a security risk.

Thanks in advance.