Hi,



I've got an app in Access 2010 which works fine on my 32-bits Windows on my laptop, but on my main machine running 64-bit Windows 7, it crashes on large data operations (update of >100000 records). The error message says to increase the LocksPerFile registery entry of the jet engine, which I did. Now the update query runs fine when I run it manually from the Access interface, but still crashes with the same error when I call it from VBA. I tried to do the update with a command object, but then I run out of system resources. Some of my users are going to upgrade their system to 64-bits, so they're going to run into the same problem
Migrating the tables to SQL server does the trick, but I can hardly force the users that are using the app for more then a year without problems on access 2010, to buy a SQL server.

The code I use is very simple:
Code:
DoCmd.SetWarnings False
 DoCmd.OpenQuery "qupdKBS_Steps"
 DoCmd.SetWarnings True
or running a command:

Code:
    Dim cmd As New ADODB.Command
    Dim lngAffected As Long

       Set cmd.ActiveConnection = CurrentProject.Connection
       cmd.CommandType = adCmdText
       cmd.CommandText = "UPDATE tmpImportStructureXML SET isxGrantParentNode = 'stepx' WHERE tmpImportStructureXML.isxGrantParentNode Like 'step*' ;"
       cmd.Execute lngAffected
Any ideas?

Noëlla