Memory Management - No Longer Set

Should you install 32-bit or 64-bit Access in 2023?

Which version of Access (and/or Office) should you install: 32-bit or 64-bit? We go way deep into the differences and similarities between the two options.

Memory Management

Monitoring Memory Usage in a 64-bit Access Application

According to the Windows API, my 64-bit Access application uses more than 2 TB (that's *terra*-bytes) of memory. Something tells me that's not right...

Memory Management

Virtual Machine Memory: An Explainer for Access Developers

Virtual machines present an interesting twist when it comes to memory management issues in Microsoft Access.

Memory Management

Virtual vs. Physical Memory in the Context of Microsoft Access

Are you noticing more "System Resource Exceeded" and "Out of Memory" errors in newer versions of 32-bit Access? It's not your imagination. Here's what's going on.

COM

Managing Memory in COM

We continue on with our restaurant analogy to explain the concept of reference counting and COM object cleanup.

Memory Management

Memory Management in VBA: 3 Keys to Avoiding Memory Leaks

Managing memory in VBA is a piece of cake, especially if you follow three simple guidelines.

Advanced

64-bit Unsigned Integers in VBA

VBA is missing a data type. The workaround--while not pretty--is at least straightforward.

Memory Management

Large Address Aware Flag

Getting a lot of "Out of memory" errors in newer versions of Access? This trick can more than triple your available memory in 32-bit versions of Access.