Did you try MS Support? They should be able to help you with a fix, either a workaround, or a hotfix etc..

-Chad

http://www.clrsoft.com

Software built for the Common Language...

See if you can break the large transaction up into mutiple smaller transactions.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime

You might be able to do it with a linked server to your Access DB. However, I would call into MS SQL Server support. Access Violations are typically...