Today, after splitting my archive table and successfully using the smaller table of more current data, today I turned to access the larger second table in a query, and it failed due to system resources exceeded. My contacts with MS online chat and by phone have been to their staff who in essence told me they don’t know the answer as Access is a specialist product, and I have to pay MS a fee to have it investigated.
If it is just a forum for solutions, do you know how one would tell MS about this? This is an obvious problem but I don’t know if this forum is just a discussion that is trying to find work arounds rather than the supplier dealing with the problem. Is this matter being looked into at MS to your knowledge?įirst time user, and I don’t know the procedure. If unwinding the update resolves the problem, I’m eager to Hepworth hello, George. I didn’t buy a good quality computer to have to close applications to be able to use Access. I almost got through an entire process after closing teams, outlook and excel. I did find that some of the “exceeded” errors can be prevented by closing other MS apps. My code is failing in many spots and it is extremely difficult to do work arounds. The database is made to query data, not to fail because of record count. To get around resources exceeded problem, I have had to write code to work around queries and table updates to my archive table. I use Office 2016 Professional, and now my machine is running Office 2016 Professional again. Last Thursday week, MS updated Win 10, and they also have me Office 365 (for no apparent reason Office 365 went off my system on Wednesday, whether MS did it in the background I don’t know). The MS help people are no use, claiming no knowledge. This issue only arose after a W10 update, and then MS updated my Office programs on Thursday. TodayI am trying to devise other work arounds that will allow me to continue to add more records to this table, by Copying the 100,000 file to a temp file, clean out original, do my updating to original which has 0 records, then return the temp records.īut now, Access won't even let me do the Copy of the original table, reporting system resources exceeded.
Occasionally, system resources when using it in form queries, but I closed that form and didn't bother proceeding with that one. Yesterday, my DB was mostly working with the cut down 100,000 record size table. I managed to move out 300,000 of these records into another archive file. The table where the system resources exceeded error appeared had 400,000 records. The more I try work arounds in my DB, the worse it appears to be. Start.exe /affinity 1 C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE d:\Documents\Racing Do you mean I should install Access 2010? I am using Access 2016. First, in your first reply, you said version 2010.
0 kommentar(er)
