[MSAccessProfessionals] Error Out of Memory - How big is too BIG for MS Access?

Hi,

I need experts advice on how big to too BIG for a single MS Access file?
We are struggling with a nasty "Out Of Memory" bug that stops us far too frequently.

As soon as it appears, it undoes the most recent written code - eventually failing to compile the file.

What I already have tried (temporarily solves the problem)
=============================================
- Compact & Repair
- Creating a brand new ACCDB then exporting all objects to it.
- Decompile 

Maybe we have a really large MS Access application that consists of 
1452 Forms
1500 MS Access saved queries
  750 Tables (MS SQL 2012)
  450  Reports

Other Information
==============
We use RDP to connect to the Server.
Windows Server 2012 R2 on Xeon CPU with 154GB RAM
MS Office 2016 (64-bit)


Any help is greatly appreciated.

Best,
Ozair

 

 

 

 

 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116439) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_