|
Home > Archive > MS Access Multiuser > April 2005 > compacting and Repairing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
compacting and Repairing
|
|
|
| I have an application that is networked on 6 remotes (fe) and one server (be)
running windows xp. My question is usually I run standalone applications and
ruteinly compact my databases but on a network, can I compact and repair on
any remote or do I need to do it on all remotes or only on the server?
Thanks,
Dennis
| |
| Van T. Dinh 2005-04-06, 8:06 pm |
| For the 6 copies of the Front-End, you can set Compact-On-Close. and you
only need to compact the Back-End.
--
HTH
Van T. Dinh
MVP (Access)
"Don" <Don@discussions.microsoft.com> wrote in message
news:A84EBADE-64F6-4C01-B07B- 6EA9DF204CAA@microso
ft.com...
> I have an application that is networked on 6 remotes (fe) and one server
(be)
> running windows xp. My question is usually I run standalone applications
and
> ruteinly compact my databases but on a network, can I compact and repair
on
> any remote or do I need to do it on all remotes or only on the server?
>
> Thanks,
>
> Dennis
| |
| Klatuu 2005-04-06, 8:06 pm |
| Don,
Best Solution:
Set all fe and be to compact on close. This will not be a problem for the
be, because it does not close until the last user closes his fe. It is
possible to compact a be remotely, but a pain in the XXX.
"Don" wrote:
> I have an application that is networked on 6 remotes (fe) and one server (be)
> running windows xp. My question is usually I run standalone applications and
> ruteinly compact my databases but on a network, can I compact and repair on
> any remote or do I need to do it on all remotes or only on the server?
>
> Thanks,
>
> Dennis
|
|
|
|
|