Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Compact & repair cuts connection to networked mdb

0 views
Skip to first unread message

DMainland

unread,
Nov 15, 2007, 6:01:01 PM11/15/07
to
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

Tom van Stiphout

unread,
Nov 15, 2007, 11:44:22 PM11/15/07
to
On Thu, 15 Nov 2007 15:01:01 -0800, DMainland
<DMai...@discussions.microsoft.com> wrote:

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.

0 new messages