I have an Update query in an Access db on my small local buy microsoft office 2013 product key drive that updates a few columns in a table kept in an Access db on my small network.
When developing the solution, I limited the amount of records, and the process runs fine. However, after i run my full group of data I recieve the "System resource exceeded" message.
Using Access 2016 64-bit
OS is Windows 7 Professional, 64-bit with SP1
Any ideas ways to get past this System resource issue?
As stated before, this usually occurs when you execute a complex query that applies to many records. Not sure how exactly you designed your query, however, you should attempt to optimize it, then try it again.
Also, please be sure to install any available updates for Windows and cheap office 2010 installations, to make sure they are not causing you troubles.
برچسب:
نویسنده: آدرین طباطبایی