Compacting stops half way through

[Guest]

Access 2000

I am trying to compact my back end because users are experiencing problems.
They cannot print or sort certain areas... ect.

The compact progress bar goes about half way and hangs there, I let it go
for over an hour and it still did not move.

db 3,780kb prior to compacting.
The new db1 goes to 3,780 also.

If I cancel out, the db will fire up but the problems still exist. Nothing
is fixed.

Any ideas are appreciated.

Please note: Novice here. Took over this db from last db person.

Thanks,

Dave

 

[Andi Mayer]

Access 2000

I am trying to compact my back end because users are experiencing problems.
They cannot print or sort certain areas... ect.

The compact progress bar goes about half way and hangs there, I let it go
for over an hour and it still did not move.

it looks like your db is corrupted.

try from a comandWindow:

"PathNameAccess" "PathNameDB" /decompile

like this one (watch for line breaks, should be ione line)

"C:\Programme\Microsoft Office\Office10\msaccess.exe"
"d:\best-Check\v03\Best3a.mdb" /decompile

 

[Arvin Meyer]

Try using JetComp.exe:

http://support.microsoft.com/kb/273956
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Arvin,

Jetcomp crashed halfway through also. Actually kicked me out. It did create
a new db, but becuase of the abnormal exit I can only assume it is corrupt
also.

??

NEED HELP ON THIS PLEASE. There are about 10 people that depend on this
database.

Dave

 

[Guest]

Andi,

.... this is embarassing... I cannot find msaccess.exe on my PC. Search turns
up nothing and using "C:\Programme\Microsoft Office\Office10\msaccess.exe" or
"c:\program files..." does not work as there is no msaccess.exe in the
Office10 folder.

If I look at the properties of my Access link the Target is greyed out to:
Microsoft Office 2000 SR-1 Premium and the Start in is blank.

Sorry about the stumbling...

Dave

 

[John Vinson]

Access 2000

I am trying to compact my back end because users are experiencing problems.
They cannot print or sort certain areas... ect.

The compact progress bar goes about half way and hangs there, I let it go
for over an hour and it still did not move.

db 3,780kb prior to compacting.
The new db1 goes to 3,780 also.

If I cancel out, the db will fire up but the problems still exist. Nothing
is fixed.

Any ideas are appreciated.

Please note: Novice here. Took over this db from last db person.

Did you or the previous administrator make a backup? I sure hope so -
you'll likely need it. Backups are NOT a luxury, they're a necessity!

Try creating a new, empty database, and use File... Get External
Data... Import to import objects from this database. Import them ONE
BY ONE - something is evidently corrupt, and you should get an error
message or perhaps a lockup when you try to import that table. My
first guess would be that a Memo field is corrupt; see
http://www.granite.ab.ca/access/corruptmdbs.htm for some diagnoses and
possible solutions.

John W. Vinson[MVP]

 

[Arvin Meyer]

More than likely it is not corrupt, but it may not contain all the data.
There have been corruptions that cannot be fixed with JetComp, but usually
you can even start. I suggest that you first make some copies of the files
as they are now. Then get to Tony Toews Corruption page and start working
through the solutions.

http://www.granite.ab.ca/access/corruptmdbs.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Andi Mayer]

Andi,

... this is embarassing... I cannot find msaccess.exe on my PC. Search turns
up nothing and using "C:\Programme\Microsoft Office\Office10\msaccess.exe" or
"c:\program files..." does not work as there is no msaccess.exe in the
Office10 folder.

I am sure you doesn't find it there, exept you are using a german
Version

if you are in the Dos-Box use this:
C:\>dir *msaccess* /s

it will come up with something like this on an english version:

Volume in drive C is WK2 Working
Volume Serial Number is 802F-9CA0


Directory of C:\Program Files\Microsoft Office\Office

23.06.2002 23:06 4.681.782 MSACCESS.EXE
1 File(s) 4.681.782 bytes

Total Files Listed:
1 File(s) 4.681.782 bytes
4 Dir(s) 855.541.760 bytes free

 

[Guest]

Thanks to everyones input and suggestions. I have learned a few tricks for
next time.

Bottom line: I ended up digging through the records and found a corrupt one.
Deleted it and all is well.

I will certainly try the Jet Compact next time.

BTW: Yes, I do have backups.

Happy New Year All!