Slow Over VPN and the 2 GB Size Limit

Why Is My Access Database So Slow?

Access wasn’t built to work over long distances or with very large files. When a database is shared from a network drive, each user’s computer pulls data across the network to process it. That works on a fast office network. Over a VPN or a slow connection, the same database can take minutes to open a form.

Size is the other limit. An Access database file can’t grow past 2 GB, and that limit includes empty space left behind by deleted records and temporary data.

Common causes of slowness

  • Users running the database over a VPN or across offices
  • Queries and forms that pull entire tables instead of just the records needed
  • Missing indexes on fields used to search, sort, or join
  • File bloat from temporary tables and deleted records that haven’t been compacted
  • An unsplit database that every user opens over the network

How to fix it

  1. Compact and Repair regularly. Do it on the back-end after hours, when nobody is connected, and keep a backup first. Compacting reclaims empty space and often makes a large difference in file size.
  2. Split the database if you haven’t already, and give each user a local copy of the front-end.
  3. Use Remote Desktop for remote users instead of a VPN. The database runs on a computer in the office, so only the screen travels over the internet.
  4. Add indexes to fields you search, sort, or join on frequently.
  5. Move temporary tables out of the back-end into a separate local file, so they don’t bloat the shared database.
  6. Keep a persistent connection. A developer can keep one hidden form linked to the back-end open while the database runs, which prevents Access from reconnecting over and over.

Approaching 2 GB?

If your file is past roughly 1.5 GB after compacting, plan your next step now. Waiting until it hits 2 GB usually means an emergency. Options include splitting data across back-ends, moving it to SQL Server while keeping your Access front-end, or rebuilding on Power Platform.

Book a free diagnostic and we’ll tell you which path makes sense for your database.

Scroll to Top