Database Can't Find Itself?

  • Thread starter Thread starter Tom Lake
  • Start date Start date
T

Tom Lake

I have an mdb called SCU that's stored on a network drive, R: which is
mapped to a directory on the server. When I open SCU, it starts running
then gives the error message Can't find R:\SCU.MDB! The program continues
to run behind the error window. I click OK and the message disappears and
the program continues to run to completion. What the heck could be
happening?

Tom Lake
 
Tom Lake said:
I have an mdb called SCU that's stored on a network drive, R: which is
mapped to a directory on the server. When I open SCU, it starts running
then gives the error message Can't find R:\SCU.MDB! The program continues
to run behind the error window. I click OK and the message disappears and
the program continues to run to completion. What the heck could be
happening?

Tom Lake
Click to expand...

It isn't Access that is making the mistake here, it's Windows. I'm guessing
that you are launching Access using a shortcut, and for some reason it's
taking a long time to get the database open (slow network, a lot of startup
code in the database, or some such). As a result, Windows is getting
confused and concludes that the shortcut has failed.

To stop the error message appearing, you need to get the database to open
faster, which means establishing and fixing the reason why it takes as long
as it does.
 
Brian said:
It isn't Access that is making the mistake here, it's Windows. I'm
guessing
that you are launching Access using a shortcut, and for some reason it's
taking a long time to get the database open (slow network, a lot of
startup
code in the database, or some such). As a result, Windows is getting
confused and concludes that the shortcut has failed.

To stop the error message appearing, you need to get the database to open
faster, which means establishing and fixing the reason why it takes as
long
as it does.
Click to expand...

Thanks! I'll see what I can do about speeding it up. You've saved me what
little hair I have left. ;-)

Tom Lake
 
You could try mapping the shortcut to SCU.mdb through Network Neighborhood
rather that the mapped drive letter. Create a shortcut, click Browse, click
Network Neighborhood, then drill down to the file. This system had the
additional advantage of working for any computer on the network no matter the
mapped drive letters. Don't know if it will help in your case, but it's
pretty easy to give it a try.
 
Back
Top