SQL Server Desktip Edition

J

Jani Jalkala

Is there a limit for clients (Access .adp instances on separate computers)
that can simultaneously connect to SQL Server Desktop Edition that ships
with MS Office XP Professional?

I'm aware that more than half a dozen simultaneous users may slow down the
performance, but my client is having a problem making more than 4
connections (at all) to a database running on the server, after upgrading
from the MSDE that came with Office 2000 Pro.

According to their report, the older version of MSDE was 7.00623 (worked
fine), and the newer (aka SQL Server Desktop Edition) is 8.0049 (fails to
connect more than 4).

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 can't connect to SQL Server 1
Slow connection from Access 2003 to SQL Server 2008 1
Using Access 2007 adp project files with SQL Server 2008 Express 3
number of connections 4
Opening 2003 ADP in 2007 fails even with newly defined SQL Serverconnection 12
Troubleshoot connecting client to SQL Server instance on a server 6
SQL Server Compact Edition? 3
Access Runtime .adp To MSDE? 5

Top