Turn Rollback off

[Oliver1]

I am trying to update a remote database using the following SQL statement, it all works fine but my computer runs out off memory and I get an error saying I will not be able to rollback this update. Fine but this message must interupt the remote link or something, because the update will then not work. So I am forced to do lots of updates of about 5000 records at a time rather than doing the full 10000 at once, and it is really annoying me. Can I turn this feature off.
Hope somebody can help.


INSERT INTO calls ( CallID, ContactID, CallDate, CallTime, Callername, Notes, CallerCompany, ActionTakenID, EmployeesID, ShortMessage, CallerNumber, Charged, OperatorID, DDI )
SELECT [callslocal].[CallID], [callslocal].[ContactID], [callslocal].[CallDate], [callslocal].[CallTime], [callslocal].[Callername], [callslocal].[Notes], [callslocal].[CallerCompany], [callslocal].[ActionTakenID], [callslocal].[EmployeesID], [callslocal].[ShortMessage], [callslocal].[CallerNumber], [callslocal].[Charged], [callslocal].[OperatorID], [callslocal].[DDI]
FROM callslocal

 

[ddmcn]

Remote Platform?

Oliver,

What is the platform for your remote database...Oracle, Sybase...

 

[Oliver1]

MySQL

The remote database is MySQL. Not sure that matters though as the hangup seems to be with the Access side.