MS Access: Question about connecting to back end SQL DB through web server

So is it possible to use microsoft access as a front end for form, query, etc development and connect to SQL Server back end through a web server using a ODBC connection from workstation Data Server Name? What port would this typically use? What is all involved with this type of setup? What difficult开发者_StackOverflow中文版ies may arise from this setup?

Thanks Justin

Assuming you mean the SQL database is on a web server and you are not talking about calling web services then it is very easy. Access allows you to link tables from any ODBC source and work with them as if they are normal tables (some restrictions apply). If you want to open the tables in code then you can use ADO to open up a connection and then manipulate the data that way.

The easiest way to link the tables is to make a DSN using the program odbcad32.exe which you can find in this folder on XP “C:\WINDOWS\system32” Once you do that you just go into access and link the table using that DSN