Compact & repair cuts connection to networked mdb

[Guest]

Whenever I do a compact and repair of an Access2K mdb I share over a peer to
peer network, one or two PCS lose the connection to the file. The only way I
seem to be able to re-establish the connection is to go to the PC the file is
on and move it to a new folder and create new shortcuts on all the other
networked PCs. What is going on? Any help would be greatly appreciated.

 

[Tom van Stiphout]

On Thu, 15 Nov 2007 15:01:01 -0800, DMainland

You have a single MDB with the tables and forms etc.?
That's a not-recommended configuration, and you will suffer side
effects, like the one you are reporting.
Split your database in front-end and back-end.

-Tom.