Win 7 Pro x64 – Not enough server storage is available to process this command January 19, 2012
Posted by Cowboy in Uncategorized.Tags: 7, file, server, storage, windows, x64
add a comment
You need to tell Windows that you want to use the machine as a file server and that it should allocate resources accordingly.
HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\LargeSystemCache
Set the registry key to ‘1′:
Set the registry key to ‘3′:
Access 2010 Crashes January 11, 2012
Posted by Cowboy in Uncategorized.Tags: 2010, access, crash, database, vba
add a comment
You receive random crashes in certain data
After installing Office 2010 SP1, you may receive random crashes when opening objects in certain databases and when trying to open the VBA window in those databases.
Workaround: UPDATE: Microsoft is aware of the issue and has scheduled a fix to the VBE7.dll in the October 2011 Cumulative Update. You can workaround the issue by performing the following steps to decompile and recompile the database.
1. Make a copy / backup of your database.
2. On the problematic machine decompile the database by running the following from a Run command line: /decompile ex. C:\test.accdb /decompile
3. Close the database.
4. Open the database again normally.
