I plan to update my workstations from 3MHz XP machines running Access2K to Access 2016 running on faster machines.
The reason I'm upgrading is in hope that I can get better performance on the workstations side. I have a split FE/BE (eight linked mdb databases, 3 MS SQL databases with millions of records).
The ONLY applications we use are Access, Outlook, and Chrome/IE.
The server is Windows 2003.
(I realize there will be network and BE performance concerns but I'm not addressing them at this time.)
1. Windows 7 or something newer?
2. CPU: Any specific CPU? or # of Cores (4 or 8)?
Any suggestions would be appreciated if I left out anything important.