I've been reading all of the threads regarding compacting and I've got
something that I haven't seen before. I read through the excellent
information at www.granite.ab.ca but did not see this covered.

I have a database that won't complete compacting. It creates the new
file and begins the compact procedure but then stops. What's weird is
the database comes back up and I can do things but the "compact"
progress bar stays displayed. I see this disk light flicker about
every 5 seconds (although that could be anything with Windows.) If I
exit Access, then try to shut down, Windows complains that Access is
still running.

I found the code to import database objects from one file to another.
I got this to work just fine but when I try to compact the new file,
the same thing happens.

I tried JETCOMP and it crashes, both on the original file and the file
into which I imported the stuff (through code).

If I open up a blank database and do a "normal" import, it seems to
bring in all of the tables and other objects then says it's importing
"&relationships" and hangs.

The database has been acting "weird" lately which is why I'm trying to
get a clean repaired copy but I don't know what to try next.

Everett

Everett Sumner wrote:
Does it fully compile ok?
A slight error might see Access hanging e.g when trying to create an mde and
there are code errors.
What about importing to a new db bit by bit and compacting after each
import? You might find the culprit that way.
Can you create a new db and compact OK?

Everett Sumner wrote:
Can't say I know anything about linking tables - the only solution seems to
be to shorten the connect string, which might mean manipulating filenames
via some other means.

Hope you get it sorted.

We had to moved the other database but it was quite infuriating how
difficult it was figure out what the problem was.


"Deano" <martinday66999 (AT) hotmail (DOT) com> wrote