I have two applications used by one company. Both systems are MS Access 2010 Accde front ends to MS Access Accdb data files. I recently upgraded both systems from Access 2003 running in Windows 2003 because the old Windows 2003 servers were dying. We run two terminal servers to one file server. We are running Symantec Endpoint Protection. Both systems are running Record Level Locking
The system on startup for each user will make a new copy of the accde file from the source library to their working directory and the old file is deleted. I have found that it is faster just to swap out the files than to compact the original file on close each time.
System one, Order Entry is used to create orders. Each user may open two copies of Order Entry, one for Company A and a second for Company B. System One has up to 11 users. So we can have up to 22 versions of MS Access 2010 running on the two Win2008R2 TS. These servers have plenty of resources and we barely even tax them.
System two is the warehouse. We have 7 versions of MS Acceess running the Warehouse software.
The data files are broke down into about 10 different accdb files on a common data shared drive on the file server.
We are running MS Access 2010 32 bit runtime (WITHOUT SP1) on the Terminal Servers.
PROBLEM: after upgrading to 2010 and installing the hotfix to increase performance we have found that we are blowing 3035 Resource errors. We have adjusted the MaxLocks and Buffer and currently have each at 350,000 and 50,000. Searches are fast 10 times in a row and then we will pop a 3035 doing the exact same thing. Invoice posting fails every time. Payment posting fails.
This afternoon, no one was working at the site, I logged onto the Terminal Server in a user session and ran EVERYTHING without blowing any errors! It is as if the conflicts on the data files caused by multiple users are causing the 3035 error.
We have contacted Microsoft and have a ticket open with them. They suggested the MaxLocks and Buffer settings to find a sweet spot. They also suggested running in compatibility mode. We have tried Win7, Win2003, WinXP Sp3. None made any difference.
We do have one Windows & 32 bit PC hooked up to the network that has MS Access 2010 installed on it. We do not blow any errors with this PC using the same files in the same location on the file server.
Any guidance as to what is going on here will be greatly appreciated. We have lots of time in on this project and it seems as if we are spinning our wheels.
Thanks in advance for any advice.