Access WIndows 2012
Posted on 2014-10-30
I have 2 servers on my network.
Server A: Windows 2008 SP2 32bit (6 years old)
Server B : Windows 2012 R2 Essential 64bit (new server)
I have an old ACCESS application (4 users) running on Access 2003. The application is a single "small" 60K DBF file (but many tables, many queries, high complexity). it has been developed internally many years ago and runs fine on Access 2003 (client) on Windows 2008 SP2 (server)
WHen the DBF is simply moved to server2 (Windows 2012 R2 64bit) it becomes very very slow. About 3 time slower than on Windows 2008. When a single person open the DBF file it is more or less OK to work but when 2 persons open the DBF file at the same time it becomes 5 times as slow. I am not even trying with 3 or 4 persons simultaneously...
Database on Server2 becomes very very sensitive to the fact that 2 (or more) persons are working at the same time on the DBF
Network switch has ben replaced and all PC are now on 1 Gb
I have done many tests and I am out of ideas now...
If someone could help...