Access 2000 comes with version 1 of MSDE, whereas MSDE 2 shipped with Access XP. Most of my clients have access 2000, and I have been unable to find any documentation on weather an Access 2000 project can be used MSDE 2. If so is there any benefit in doing so? I do plan to move over to SQL 2000 Server in a few months and would like the ease that move as much as possible.
MS did make some changes to MSDE 2000 that should be noted however. The install now defaults to TCP/IP instead of named pipes as the default network library. MSDE shipped with MDAC 2.6 which includes a new version of the DBNETLIB protocol. This new version allows connections to SQL Server 6.5, 7.0, or 2000 and supports named instances. Consequently, clients with older versions of MDAC (ie 2.5) will not be able to connect to an installation of MSDE 2000 installed with the default settings.
All workstations would need MDAC to be upgraded.(If Office XP not installed, any Windows desktop before Windows 2000 SP3)
you can change the install to use named pipes
you can configure the server to use a fixed port number and alias