Hello We are using Access 2003 (SP2) to access a remote SQL 2000 database, linking the tables with 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 public CDMA mobile network) - the cause of this is not in question - there is no way to fix these network problems. 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. Re-linking the tables through VBA is not an option - I have tried this and it takes too long, but if there is a way to refresh the links, or to reset the driver status that might be the way. Any help would be much appreciated. thanks ! Rob
hi Rob, saikosounds@gmail.com wrote: > I desperately need to find a way to "reset' the driver when this > happens so that we don't have to keep restarting access. Try to get a new session by opening a new passthrough query. Otherwise switch to ADODB.Recordsets bound to your forms and reports in your code. Reopening a new ADODB.Connection should work always. mfG --> stefan <--
