Access 2007 Database over VPN Running Slooooooooooow...
Posted on 2008-11-03
I've been trying to find out more about this but have largely been unsuccessful. We have a small Access 2007 database roughly 6MB that some of us access via VPN when we're able to work from home. We have a team of about 5 and we don't all access the DB at the same time. When we're in the office, the database performs just fine, but remotely (VPN), it's so slow it's practically unusable. We recently upgraded to Office 2007 from 2003 and upgraded the database from 2003 to 2007. When the DB was 2003, we didn't really have any performance issues via VPN, so this only started after the upgrade. The database is incredibly small -- only a few forms, macros, etc in the DB. When the database was 2003, it was about 40MB so I don't understand how that performed better.
So if anyone can explain why a much smaller 2007 DB is so much slower than a 40MB 2003 DB, or how to speed up the performance, I'm all ears. This is driving me nuts.