Hi,

Thanks to anyone who can help.

We are in the process of renewing all our old Win Me clients, but this
cannot be done overnight and we have many old Me clients still attached to
the domain. Unfortunatley we suffered a server (SBS 2003 premium) crash and
rebuilt the server with SQL 2000 server. Before the server was rebuilt the Me
clients all had a data source that allowed us to use Access to query a
database. Since the rebuild the old data sources do not work and neither can
we create a new data source, when we get to the authentication method,
regardless of whether we choose NT user or SQL the SQL server cannot be
contacted.

The only differences between the old and new servers are:-
the old server had no name for the sql server whereas the new server is
called SQLSERVER
the old server was sp3a and the new server is sp4

The server name that we were using successfully in the data source for the
old server was AA01. The new server has excatly the same server name (AA01)
but neither AA01 nor AA01\SQLSERVER will give a connection. Neither will
substituting the server ip address (192.168.16.2) for AA01