472,111 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,111 software developers and data experts.

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 1839

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.