Compact Error

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

Hi,
I have an Access 2000 applicaiton, with Front & Back End
in the file server. Yesterday, the system was
crashed :"User may have unexpectedly quit Access while it
was open", I noticed the Frond end size got inflated,
after compact the size down from 131 mega to 6 mega, but
there is an MSysCompactError table, with error
description:could not find field "Desription" ,
errorTable:AccessLayout. Why the Front end size increased
that much? What's the AccessLayout table?
Thanks for your kindly input.
 
For the FE/BE arrangement, you should have the BE on the file server but
each user should have his own copy of the FE on his/her desktop. This way,
each user will use a separate copy of the FE and only share data in the BE.
This way, you reduce the network traffic as well as the likelihood of
corruption the FE. Also, a corrupted FE will only affect 1 user, not all
users. Also, the FE won't bloat that much since each copy is only used by
one user. You can also use the Compact-On-Close option to compact the FE.

It sounds like your FE (on the server is corrupted). See if Tony Toews'
article helps:

http://www.granite.ab.ca/access/corruptmdbs.htm
 
Back
Top