ODBC And Error -7776 From Access And SQL Server.

I have a weird problem.

I have an SQL Server running my database, I connect to it through a VPN, I'm linking tables with it using ODBC from my Access database. I can see the data without problems. But when I attempt to run a query in my Access which basically creates a local copy of a table I sometimes get the following error: -7776.

After having searched a bit for the error, I found out that it is an ODBC error that is concerning date/time conversion.

-7776 SQLGetData(SQL_C_TIMESTAMP)
Illegal date/time value returned.

I do not have any timestamp datatypes in my SQL server table, they are all datetime datatypes. I have checked the data, all of the dates seem legal dates, no NULL values.

The problem is not consistent, it does not occur at every attempt, it appears about every third time but not consistently. And not at the same location each time. If I stop importing my datetime column, I avoid the error.

From my home location I do not get the error, and neither if I run without my company firewall. However from within the company firewall the error occurs at random times, and at random locations (always the datetime column though).

I find this extremely weird, and even though the problem could seem to be my firewall I somewhat doubt that, since I'm able to see the data if I use a SELECT query, but not when making a Make table one. And since it is always concerning my datetime column (which is not called datetime, datetime is simply the datatype).

I am using Access 2003 and SQL Server 2005.

If you need any further details, please do not hesitate to write.