I have an application with a Microsoft Access front end, connected to a SQL Server database as the back end. Inquiry on a support ticket told me they don't know how to accomplish this, and that I should ask in the forum. In Windows, of course, I use ODBC drivers. Could someone help me do this in Winhost? Thanks!
Your blog shows how to use an ODBC connection in Access. That I'm well familiar with. What I was looking for is how to host both Access and SQL Server inside Winhost, so that someone can see my application online. Am I barking up the wrong tree? Thank you very much.
Yes. I'm afraid that is not possible, or at least, I don't know of a way. Access is a "console" application. The only way that I can think of making this work would be with WebDAV, but then I don't think you could secure it.
The blog shows how to establish an ODBC connection between front and back end. It doesn't tell me if the connection is encrypted or if the data stored in the database is encrypted. Is encryption possible? Is is an option on the creation of the database? What form of security governs this type of connection?