Hi,
One of our developers reported that his Access database was slow and asked us to exclude the file extensions .accdb and mdb from the AV scanning. I went a step furth and turned AV off to prove that AV wasn't causing the issue.
We have clients using Windows 7 [32bit] with Access 2010 accessing a database [.accdb] via a mapped drive to a Windows 2008R2 share. The .accdb file has SQL links to two other servers. The database takes 25 seconds to open.
If I copy the .accdb file to my c drive the database open in less than a second. If I copy the .accdb file to another mapped drive that is host on a server 2003 server the database opens in less than a second.
I have tried turning off SMB2 on the Server 2008R2 server, made no difference.
Does anyone have any idea why the database is slow to open if the .accdb file is accessed via a mapped drive to a Server 2008R2 server?
Thanks