Usually the best method for something like this, if I understand what you're working towards is to use a web front end as opposed to using an Access front end.
Your options at that point would be much more fluid, and provide more security to the SQL Database, rather then exposing direct connections to the database.
This of course would require new code to be created to link to the database and graphically display the forms that you use in access.
The simplest way (In my opinion.) to code this would be to use .Net to build the web application.
Main Topics
Browse All Topics
by: k_murli_krishnaPosted on 2009-08-20 at 09:36:47ID: 25144523
You assign direct IP to SQL Server and give bypass from proxy server/firewall and if it is connected to internet anyway then once connection is configured at remote clients of various type i.e. SQL/Java/Tools using ODBC, JDBC, OLEDB, database can be connected to.
Another way is via VPN connection. For this you can use openVPN/SecureID/Kerberos authentication. You can go for digital certificate one as well. Also, configure for distributed i.e. homogenous (All will be SQL Server) databases OR federated i.e. heterogenous databases (1 will be SQL Server, 1 Oracle, 1 DB2 etc.) connection, access & operations. For SQL Server you can use a four part name i.e. server/instance.database.o
I the systems are individual PC's connected using dial up modem or a broadband connection, then there is no need to bypass proxy/firewall or for a VPN connection. Protocol used across the internet/extranet/intranet