S
Simon Maystre
On MS Access 2003 with SP2 when trying to run an update query that exports
data from an Access table to a SQL Server 2005 table (ODBC connection) it
gives a message saying that there isn't enough disk space to undo the query
then gives a message 'System resource exceeded' and the query doesn't run.
I have turned off using transaction for this query and tried setting the
ODBC timeout in the Jet 4 registry setting to 0 so it shouldn't timeout but
still get the same error. The table I am trying to append from has 160,000+
records.
data from an Access table to a SQL Server 2005 table (ODBC connection) it
gives a message saying that there isn't enough disk space to undo the query
then gives a message 'System resource exceeded' and the query doesn't run.
I have turned off using transaction for this query and tried setting the
ODBC timeout in the Jet 4 registry setting to 0 so it shouldn't timeout but
still get the same error. The table I am trying to append from has 160,000+
records.