Access .mdb files slow to open

Question

OS:  Windows 10 Version 1709 Build 16299.967

MS Office 2013 (32-bit)

Installed applications:

Microsoft Access 2013

Microsoft Access Runtime 2016 x86

Access exceptionally slow in opening .mdb files.  Even smaller files (10MB or less)--regardless of file location (local or network)--take several minutes to open.  Larger files, of course, take even longer.  Attempts have been made with multiple .mdb files.  Environment is a public sector enterprise (1500 clients) in a large building and this is occurring on client machines (some, not all) in different physical locations serviced by different network switches--so most likely not a network issue.  Adjustment of settings within Access have not yielded any positive results.

The odd thing is if user opens an instance of Access and opens these same files (Open other files->Browse) using the open application, the files open almost immediately.

Please advise and thanks in advance!

Answer 1

The same isn't true if working with accdb files?

You say "on client machines (some, not all)", what's the difference between machines?

• Build No
• User Permissions
• ...

Have you tried performing an Office Repair?

Yours is not the first post mentioning similar symptom, so I've reached out the the Access Dev Team, we'll see what comes of it.

Answer 2

.accdb has same results--sorry I didn't include that with my submission

all machines tested were v1709 build 16299.904 except one that was v1703 build 15063.1631

Wouldn't deduce permissions since results are the same with files locally stored or in a network location--and there aren't any permissions set on these .mdb files (they are permitting applications uploaded by a particular industry)

I tried Office repair which yielded no positive results...

Thanks for all your efforts!

Answer 3

Hi Corey,

Does this happen only with Access files?  Does double-clicking on an Excel or Word file have the same issue?

When you double-click the Access database, does Access open right away, and then take several minutes before getting the database open, or is there a long delay before Access opens?

Is there any kind of progress indication, or hourglass, or other indication that something is happening during this time?

Does it make any difference if Access is already running or not when you double-click the file?

If you right-click on the file to open a context menu, is the first thing on the menu "Open", in bold text?

Thanks,

Shane Groff

Access Engineering

Answer 4

This happens only with Access files--Word and Excel open much, much faster

There is a long delay before an instance of Access even opens--once that is open the database opens almost immediately

The "blue circle" progress indicator is visible until the file opens

If an instance of Access is open and the desired file is double-clicked there is still a significant delay and the text in the upper left corner of the window reads:  Access (Not Responding)

However, if the desired file is opened using Access (Open other files->Browse) it opens immediately from local or network location

"Open" is the first choice displayed in the right-click context menu and opening the file with this method is even slower from either a local or network location

Answer 5

If you disable your virus protection for a moment, and perform the same tasks, does the symptom still present itself?  The reason I ask is that in recent memory, our virus software used to scan mdb/accdb files on open (ie: dbl-click or right-click open), and I believe the Access.exe was scanned as well when that scan thread was started. Until our network guys fixed that, we experienced similar symptoms.