Hello

We are using Access 2003 (SP2) to access a remote SQL 2000 database,
using ODBC with MDAC 2.8

This is an intermittent problem and it occurs on all the clients
(mostly winXP Pro)

The problem is that from time to time, the ODBC connection fails and we
get one of several errors:
ODBC--call failed
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
(#10054) [Microsoft][ODBC SQL Server Driver][DBNETLIB].General network
error. Check your network documentation.
or
ODBC--call failed
[Microsoft][ODBC SQL Server Driver][Communications link failure (0#)

We know that sometimes there are network problems (we connect accross a
CDMA mobile network) - the cause of this is not in question......

Retrying the operation immediatly returns the same error but when we
close and re-open access and re-run the operation, and then it will
work straight away.

So, it seems that the driver enters a "failure state" - which is reset
when access is closed and re-opened.

I desperately need to find a way to "reset' the driver when this
happens so that we don't have to keep restarting access.

Anyway help would be much appreciated.

thanks !
Rob