none
Access 2010 - run time error 3035 - System resource exceeded

    Question

  • I moved a program access  .Mdb on a Macbook pro windows 7 64 bit with installed Access 2010.
    The program creates a local table data from various fishing some linked tables to the database, some are linked tables to excel and other local SQL tables The problem is that after a while that processes access 2010 returns the error "run time error 3035 - System resource exceeded "the block occurs at random is not always the same query that crashes if I click debug, and then within the F8 to continue processing the query and then go hang after a few queries.

    If launch elaborations smaller the program goes considered that the table which generates does not exceed 40000 rows and the database is smaller than 1GB.

    The strange thing is that the program works perfectly on another macbook pro (hardware less powerful) with the same configuration windows 7 64 bit and Access 2010, I tried to increase the timeout for the DDE, I tried to compact and repair the  database but the error always comes out.

    If launch processing smaller the program is considered that the table that generates does not exceed 40000 rows.

    I await your precious help.

    Thanks so much in advance.

    Sincerely

    MG

    Thursday, May 16, 2013 1:29 PM

Answers

  • Hello MG,

    If your program did not work at all I would say that there is a problem with your program.  But since it runs on one machine and not the other I suspect there is either corruption of your database on one machine or a difference in the configuration of Office or Windows on the two machines.

    I would first repair the database by clicking on Database Tools on the ribbon, then Compact and Repair Database.

    If this does not resolve the problem do a repair installation of Office 2010 and be sure that all Office 2010 and Windows updates have been applied by clicking Start, All Programs, then Windows Update.

    -Bruce

    Friday, May 17, 2013 3:31 PM

All replies

  • Hello MG,

    If your program did not work at all I would say that there is a problem with your program.  But since it runs on one machine and not the other I suspect there is either corruption of your database on one machine or a difference in the configuration of Office or Windows on the two machines.

    I would first repair the database by clicking on Database Tools on the ribbon, then Compact and Repair Database.

    If this does not resolve the problem do a repair installation of Office 2010 and be sure that all Office 2010 and Windows updates have been applied by clicking Start, All Programs, then Windows Update.

    -Bruce

    Friday, May 17, 2013 3:31 PM
  • This worked for me:

    https://support.microsoft.com/en-us/kb/2726928

    After you install the hotfix package, follow these steps to enable the hotfix:
    1. Click Start, click Run, type regedit in the Open box, and then click OK.
    2. Locate and then click one of the following registry subkeys:
      • On 32-bit versions of Access on 32-bit versions of Windows or 64-bit versions of Access on 64-bit versions of Windows:
        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines
      • On 32-bit versions of Access on 64-bit versions of Windows:
        HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines
    3. On the Edit menu, point to New, and then click DWORD (32-bit) Value.
    4. Type WorkingSetSleep, and then press Enter.
    5. In the Details pane, right-click WorkingSetSleep, and then click Modify.
    6. In the Value data box, type 1, and then click OK.
    7. Exit Registry Editor.

    No more 3035 Errors!

    Regards Richard

    Thursday, October 13, 2016 7:30 AM