Two databases open simultaneously

[Dave Bradshaw]

I have just encountered an unusual problem. We are running Access
2000, and accessing the databases over a network.
Today we are finding that we are not able to open two of the databases
at the same time. If one of the databases is open, and we try to open
the other, all that happens is that the focus moves to the originally
opened database, restoring the window if necesary. We have tested this
behaviour on two machines, and it is the same for both.
If we try to open any other databases we do not have a problem.
I don't know if it is related, but this morning I ran compact and
repair on our most frequently used databases.

 

[Bill Mosca, MS Access MVP]

Dave

I've seen that happen but can't pinpoint the cause.

How are you opening the databases?

 

[Dave Bradshaw]

We are opening the databases from shortcuts on the Desktop or the
Start Menu

 

[Bill Mosca, MS Access MVP]

Dave

Are you using a target path that includes msaccess.exe? I find that if I do
so like this one I don't get that pesky failure that you are getting.:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\Databases\MyDatabase.mde"

 

[Dave Bradshaw]

Thank you, it worked

 

[Bill Mosca, MS Access MVP]

Dave

Weird, huh?

--
Bill Mosca, MS Access MVP

Thank you, it worked