Results 1 to 5 of 5
  1. #1
    albaker is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    14

    System Resource Exceeded - can't compact, can't do various queries, can't migrate to SQL


    We have 12 Access databases, all created in 64-bit Access 2016, five of these databases are 1.3 GB to 1.9 GB in size. I deleted some of the data in the five larger databases and attempted to compact them, but for each I get the system resource exceeded message. Occasional queries will also throw this error. I decided to migrate the Access databases to SQL, but I get the same message. The database format is ACCDB, and I can't even export these to MDBs because of the resource exceeded message. I'm on a Dell Latitude 5501, with less than 50% memory (of 16GB) in use during the process, around 120 GB free on the drive, and an i7 processor that is basically idling. I've been working on a solution off and on for two weeks, and I simply can't make any progress. I've Googled a bunch, but I've not found the answer. Any suggestions?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    albaker is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    14
    Thanks - looking into this now.

  4. #4
    albaker is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    14
    That fixed the problem! Thank you so much.

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Excellent, happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 22
    Last Post: 01-02-2020, 11:26 AM
  2. Getting error System resource exceeded
    By princydisney in forum Access
    Replies: 1
    Last Post: 08-22-2017, 04:55 PM
  3. System resource exceeded
    By PJ Crittenden in forum Import/Export Data
    Replies: 1
    Last Post: 10-10-2014, 10:28 AM
  4. System resource exceeded
    By fdormoy in forum Access
    Replies: 7
    Last Post: 07-17-2014, 10:50 AM
  5. System resource exceeded
    By ahmed_ae in forum Queries
    Replies: 1
    Last Post: 08-01-2013, 12:53 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums