we have a client who was running an old bespoke access (2000 – 2003) database on SBS 2003 which runs their optometrists software. They were complaining of performance issues so we recommended upgrading the server.
we talked to the tech of the access database authors who gave us a couple of changes to be made during the migration, and that was it.
we migrated the sbs2003 server to sbs2011 (server 2008 R2 x64) over a weekend and immediately hit performance issues with the access database.
Their tech indicated that it might be a SMB 2.0 issue so we disabled SMB 2.0 on the server, and while that did help, and allowed the database to at least run the performance is well below that of the previous server, over 10x slower.
Found a thread on Microsoft forums that indicates that it’s a problem, and that unless you upgrade the access 2010 (which they aren’t going to do) there no fix.
I’d be grateful for any tips, tricks or solutions.
We’re preparing to re-instate the 2003 to put the access on, while wiping the egg from our faces.
Thanks – Murray