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.

-- 
DMainland

While I've never experienced such behavior, peer-to-peer networks aren't 
nearly a robust as having an actual server setup.

Also I suggest not doing a C&R more than once a month or even then. If you 
are having corruption or severe bloating problems, you should fix the root 
problem.
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"DMainland" wrote:

> 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.
> 
> -- 
> DMainland

Before you C & R do you make sure everyone is out of the db?
http://www.accessmvp.com/JConrad/accessjunkie/kickoff.html

Jerry Whittle wrote:
>While I've never experienced such behavior, peer-to-peer networks aren't 
>nearly a robust as having an actual server setup.
>
>Also I suggest not doing a C&R more than once a month or even then. If you 
>are having corruption or severe bloating problems, you should fix the root 
>problem.
>> 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.

-- 
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200711/1