Error 3035 Access 2007
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Tue, 11 Oct 2016 08:22:22 GMT by s_ac15 (squid/3.5.20)
Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find
Error 3035 Ffxiv
All Thanked Posts Go to Page... Page 1 of 2 1 2 system resources exceeded access 2010 > Thread Tools Rating: Display Modes 09-19-2014, 05:35 AM #1 stepone Newly Registered User Join ms access 2013 system resource exceeded Date: Mar 2004 Location: Scotland, UK Posts: 89 Thanks: 9 Thanked 6 Times in 5 Posts RUn Time error 3035 - System Resource exceeded Hi, I might become a regular poster http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-msoffice_custom/how-do-i-prevent-run-time-error-3035-system/49b66089-4486-4a83-94e2-13eced66d686 on here as I have a new job which is supporting a miscellany of Access and Excel applications, something I have not done for a few years now.... One thing I have inherited is an Access database which we use on a daily basis to run reports for customers. Each time it's used, a customer-specific dataset is imported to a table, http://www.access-programmers.co.uk/forums/showthread.php?t=269397 then update and make-table queries are run to perform various calculations before the data is copied back into Excel to create the final report. The majority of the time this runs fine, but if the initial dataset is large (> 100,000 rows) then we sometimes hit an error "Run Time error 3035 - System Resource exceeded". The solution (up to now) has been to run the same job on an old Windows XP machine, running Access 2003, which seems to be able to handle even the largest datasets. It's only our newer, Windows 7 pcs with Access 2013 which have the problem. Since XP is no longer supported we really need to get the issue with Access 2013 resolved. The process is kicked off from within Excel VBA, which opens our Master database, imports the dataset to the main table, then calls an Access VBA sub-routine, which in turn calls about 60 Access update queries and make-table queries one after the other, using docmd.openquery. So, in Excel we have ; Code: Dim acApp As Object Dim db As Object Set acApp = CreateOb
is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing http://www.vbforums.com/showthread.php?719077-Error-code-3035-question messages, select the forum that you want to visit from the selection below. Results 1 to 16 of 16 Thread: Error code 3035 question. Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Apr 23rd, 2013,09:20 AM #1 mojo69 View Profile View Forum Posts Thread Starter Fanatic Member Join Date Aug 2005 Location Wisconsin Posts 788 Error error 3035 code 3035 question. I have a VB6 app using DAO to connect with Access database. The last two days users have been getting Error Code 3035 System Resource Exceeded when doing a simple query. Example: "SELECT * FROM APHF01 WHERE (APHFCheckNo = '999999');" The table APHF01 has around 200,000 records. It is also occurring when executing on a different table with around 30,000 records. The tables have a small number system resource exceeded of columns ~20. Any ideas on why this would come up and what can I do about it? Thanks. Reply With Quote Apr 23rd, 2013,09:54 AM #2 jggtz View Profile View Forum Posts Frenzied Member Join Date May 2006 Location some place in the cloud Posts 1,885 Re: Error code 3035 question. ...and the Access database version is? ...and the Windows version is? JG ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ... Reply With Quote Apr 23rd, 2013,10:10 AM #3 mojo69 View Profile View Forum Posts Thread Starter Fanatic Member Join Date Aug 2005 Location Wisconsin Posts 788 Re: Error code 3035 question. Access 2007 Windows Server 2008 R2 Standard Service Pack 1 64 bit Reply With Quote Apr 23rd, 2013,03:12 PM #4 DataMiser View Profile View Forum Posts PowerPoster Join Date Feb 2012 Location West Virginia Posts 10,975 Re: Error code 3035 question. I am a bit surprised that DAO even works with 2007. You really should consider updating the code to ADO and the ACE provider if possible. Reply With Quote Apr 23rd, 2013,03:26 PM #5 jggtz View Profile View Forum Posts Frenzied Member Join Date May 2006 Location some place in the cl