Gijs,

What structure your database have?  I recently struggled with ODBC timing
out intermittantly when I was in the middle of converting an Access Database
(.mdb) to having a SQL backend.  Sometimes it would work fine and sometimes
things would take forever and then I would get the ODBC timing out.  I don't
recall the error number though.

For me, the issue turned out to be that the ODBC connection between the .mdb
front end and the backend SQL tables really isn't efficient.  Too much data
is trying to be crammed into the connection and it eventually fails.  The
solution in my case was converting the .mdb front end to an .adp (Access Data
Project).  Since ADP was specifically designed to communicate with the SQL
tables (without an ODBC connection) it is much more efficient.  I also had to
change some of the underlying recordsources of my forms to restrict the data
that is being loaded into them to make them more efficient.

If this sounds like it may be your issue feel free to ask me for any more
details that might be helpful.  I'm still learning but I'd be happy to point
you in the right direction.  My application is definately running much better
now.

These vague errors can really drive a person nuts!  Good luck!