JamesDBuskirk
asked on
System Resource Exceeded VB 2015 OLE DB
I am getting "System Resource Exceeded" when exporting using VB 2015 application and Access MDB file. On my development PC in VB Studio I get no such error. Dev PC is 64 bit Windows 7 PC with 8 Gig RAM. The Live PC that is incurring the error is Windows 10 64 bit with 8 Gig RAM.
Is there an option for OLDDB similar to this one below that I can increase this setting? Any other ideas? I found a hotfix for this on Microsoft web site but it has been expired and the registry entries they suggest to change do not exist on the Live PC.
SUGGESTED in other articles: "dbEngine.SetOption dbMaxLocksPerFile, 100000"
Is there an option for OLDDB similar to this one below that I can increase this setting? Any other ideas? I found a hotfix for this on Microsoft web site but it has been expired and the registry entries they suggest to change do not exist on the Live PC.
SUGGESTED in other articles: "dbEngine.SetOption dbMaxLocksPerFile, 100000"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So I'm ok to close out the question then?
I am following up on your question. Do you still need help?
If you solved the problem on your own, would you please post the solution here in case others have the same problem?
Regards,
Stacy Richard
Customer Relations