469,323 Members | 1,486 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,323 developers. It's quick & easy.

Repost: Second Database Slow To Open

Original Post:

The following problem started on my PC about a week ago and I can't
link it to any specific change. I'm using Access XP.

If I have any database open and try to open any other database by
double clicking its file in Explorer, it takes about 5 seconds to open.

Previously the second database would open almost instantaneously, as
one would expect on a reasonably fast machine.
However if I have any database open and then open a second instance of
Access by running it from the Start menu it opens instantaneously. If
I then double click any another database file in Explorer it will use
the open instance of Access and open instantaneously.
I have tried uninstalling and then reinstalling Access but the problem
remains. If anyone can give me a clue as to what is causing the
problem, and better still how to fix it, I would appreciate it.

Original Post Ends Here.

Since posting this, because of this problem and a few others I have
reinstalled Windows and all my apps including Access 2002 SP3. The
above problem seemed to disappear for a short time but is now back
again. Upon closer investigation, I have found the following:

When I try to open the second database, Access opens immediately, it is
the process of loading the actual file that causes the delay.

The problem is only apparent with mdbs, not mdes.

If I create a shortcut to the mdb that includes the path to
msaccess.exe, the file opens immediately without delay.

Obviously the file association for mdbs is msaccess.exe or they
wouldn't open at all. What I can't understand is why including the
path to msaccess.exe in a shortcut to the file resolves the problem.

Any help or comment is appreciated.

Jul 29 '06 #1
0 1714

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Yannick Turgeon | last post: by
reply views Thread by Frederick Noronha \(FN\) | last post: by
3 posts views Thread by Jeremy Ames | last post: by
reply views Thread by Doug | last post: by
14 posts views Thread by Steve McLellan | last post: by
2 posts views Thread by Sabre | last post: by
8 posts views Thread by Peter Proost | last post: by
reply views Thread by Wayne | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.