Stuart McLachlan
stuart at lexacorp.com.pg
Sat Apr 12 17:44:55 CDT 2014
Haven't come across that sort of problem for many years.but in a dim, cobweb covered corner of my brain, something stirs and gently whispers: MaxLocksPerFile A quick google tells me it can still be an issue in 2010. Check the registry setting HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines\ACE\MaxLocksPerFile It's probably 9500 - make it something like 100,000 :) -- Stuart On 12 Apr 2014 at 16:53, Bill Benson wrote: > Typo, after I created the table and before I shut down Access, I had > 3.5 of my original 4GB ram still available, and Acces was using 100MB > of RAM, as determined by shutting it down and seeing memory usage go > from 4.36GB to 4.26GB. > > -----Original Message----- > From: Bill Benson [mailto:bensonforums at gmail.com] > Sent: Saturday, April 12, 2014 4:49 PM > To: 'Access Developers discussion and problem solving' > Subject: System Resources exceeded Ac-2010 > > And now for something completely different... I tried to create a > LARGE table in Access by importing a large Excel worksheet. It was > 65000 rows by 11 columns, and each cell had 1020 characters in it. > Access created each field as Memo on import. > > Access did not tell me that system resources were exceeded during the > import, but since creation of the table, it will not open it. The > error is "System resource exceeded." > > However, I have 3.5 of my original 4GB ram still available. Access > itself is using only ______ and the database is 152MB large by testing > > Filelen(currentdb.name) > 151515136 > > Strange things are happening like I cannot even copy text out of the > immediate window and paste it here in this message. > > When I killed Access my physical memory dropped from 4.36 to 4.26 (a > RAM consumption of 100MB). > > When I re-started Access and re-opened the database, all data was > present and accounted for. > > And I can now copy and paste from the immediate window to this > message. > > What system resource is Access being constrained by? > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >