PC hosting data must open last

  • Thread starter Thread starter Simon Harris
  • Start date Start date
S

Simon Harris

Hi Guys n Gals!

I have a client who has 3 PCs:

PC 1 (Windows XP/Office 2000 Professional SP3): Hosts data and gui files
(Split DB) tables are linked via network path (e.g: \\pc1\path\data.mdb)
PC 2 (Windows 98/Office 2000 Professional SP3): Runs gui from PC 1 across
the network - Desktop shortcut: \\pc1\path\gui.mdb
PC 3 (Windows 98/Office 2000 Professional SP3): Same as PC 2

Problem is that PC 1 or PC 2 have to open the DB before PC 1 does, other
wise PC 1 and PC 2 display errors when you try to open the DB, the error is
something about 'cannot fin the file <path to file\filename.mdb> (Sorry - I
have not got the specific error)

Hope some one can help.

Thanks for reading! :o)

Simon.

--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
 
strange you wouldn't bother to spend enough time to show us the exact error,
as you might find your search for a solution would start here.

eg, WHAT file couldn't it find????

When access fires up it creates a locking file (.ldb) the same name as the
database. If it crashes unexpected the .ldb will remain on the disc, if
Access exits nicely the .ldb will be deleted when the last user exits the
database.

In the absense of any real documentation, maybe see if the PC3 is firing up
in Exclusive mode...
 
Heres the events upon loading the DB from PC1 or PC2:

1) Access loads - Displays my splash screen form
2) Hangs for a while
3) Error:

"Windows cannot find '\\server\path\filename.mdb'. Make sure you typed the
name correctly, and then try again. To search for a file, click the Start
button, and then click Search."

I click Ok, and the DB either loads fine, or Access hangs (not responding)

I've seen this happen on two seperate networks - Both of which are known to
be reliable normally.

Thanks,
Simon.
 
Back
Top