I have a frontend in Access 2010 and Backend in SQL 2008 Express R2. Even though Access is 2010 the rest of Office is 2007.
Sometimes I get a series of ODBC errors, like Call Failed or Update Failed.
The computer where SQL is installed on is Windows 7 Pro and I have read that in Win 7 there are limited numbers of TCP/IP connections. Is this true, and can this be causing the ODBC errors?
If this is the case, I guess I have no choice than to upgrade the "server" to actual server, like Windows 2008, but before I do is there a way to look at how many TCP/IP connections are actually open? Also what is the TCP/IP limitations of Win 7?
I assume that Win 2008 does not have such limits, correct?