Compacting DB Makes it Go Whacky

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan Rosenberg - 20 Sep 2003 19:49 GMT

So, I have an Acces program that is split into a front & a back end. it
runs just fine.

The other day I decided to compact the back end (using a program that calls
DBEngine.CompactDatabase, as taken from the Microsoft site). But after
compacting, the application is just simply wedged (to user a technical
term).

The front end just starts acting whacky. It complains about fields being
too small, entries that are defaulted, become empty, etc.

Has anyone seen this behavior?

--
JR

Reply to this Message

david epsom dot com dot au - 21 Sep 2003 03:29 GMT

> The front end just starts acting whacky. It complains about

If you have made any structural changes to the backend,
you have to compact the FE after compacting the BE.

Maybe you should relink the FE to the BE, but just
compacting the FE is what usually is needed.

(david)

> So, I have an Acces program that is split into a front & a back end. it
> runs just fine.
[quoted text clipped - 11 lines]
> --
> JR

Reply to this Message