Fix the Microsoft Access 2016 LinkMasterFields Memory Error Without Admin Rights
Question details
The user needs Microsoft Access 2016 to open and use a database without a LinkMasterFields insufficient-memory error or administrator privileges.

- Product
- Microsoft Access 2016
- Device & OS
- Windows 10 Home 64-bit
- Scenario
- The issue occurs on one laptop with 8 GB of RAM, while other computers can use the database without the same error.
- Observed behavior
- Access reports an insufficient-memory error involving the LinkMasterFields property even though Task Manager shows available memory. Running Access as an administrator avoids the error.
Have the affected laptop and a working computer available so you can compare their Access versions and database locations. Record the exact error text and the form or action that triggers it while Access runs normally, without administrator privileges.
Compare Access versions and reproduce the error under normal permissions
Start here to identify differences between the affected laptop and a working computer before treating the message as a RAM shortage.
Open Access on each computer and select File > Account > About Access. Record the version, build, and whether Office is 32-bit or 64-bit; the Windows architecture does not determine the Office architecture.
In Access, select File > Open and check the database path on each computer. Confirm that both computers use the same database release, and note differences in local folders, network locations, linked data sources, or installed add-ins.
Press Ctrl+Shift+Esc to open Task Manager, then select Performance > Memory. Reproduce the Access error and record memory usage; available memory means the message alone does not establish a physical RAM shortage.
If the affected computer has an older build, open File > Account > Update Options > Update Now, if available and permitted. If updates are managed or require elevation, give the version comparison to your IT support team.

Check database-folder access with your standard Windows account
Use this check when the error disappears under administrator privileges, especially if the database is stored in a restricted folder.
Arrange an Office repair if the problem remains limited to the laptop
Use this escalation when version and access checks do not explain the error. Installation maintenance may require an administrator, even though everyday Access use should not.
Use WPS Office for Documents, Spreadsheets, and Presentations
WPS Office is a free, lightweight alternative for everyday Office documents, with a familiar interface and Microsoft Office format compatibility for easy migration. It does not replace Microsoft Access, run Access database forms, or fix LinkMasterFields errors.

Frequently Asked Questions
Why does Access report insufficient memory when Task Manager shows free RAM?
The error text does not necessarily indicate a physical RAM shortage. In this case, the one-computer failure and the difference when running as administrator warrant checking permissions, Office builds, and local configuration. Use Task Manager > Performance > Memory to record usage when the error appears.
Can I fix the error without administrator rights?
You can compare builds through Access > File > Account > About Access and test database-folder write access in File Explorer without elevation. A permitted local front-end copy may help isolate a folder-access problem. Office repair, reinstallation, or changes to protected permissions may still require IT assistance.
Should I change the LinkMasterFields property to stop the error?
Not solely because the error names that property. LinkMasterFields connects a main form to its subform. If the same database works on other computers, compare the environments first. Any property changes should be tested in a separate development copy because they can change which records the subform displays.
Does Windows 10 64-bit mean my Access installation is also 64-bit?
No. A 64-bit Windows installation can run 32-bit Office. Open Access > File > Account > About Access to confirm the Office architecture, then compare it with the working computer.
Can WPS Office open my Access database instead?
WPS Office is not a replacement for Microsoft Access and does not run .accdb or .mdb databases or their forms. It can support related document and spreadsheet work, including opening Excel-format exports from Access, but the database issue must be resolved in Access.




