Access 2003 Compact & Repair Crash

D

Destin Richter

Hi. Lately, when I'm running a compact and repair on any of my databases
(new or old), I get a message that Microsoft Access has stopped working. So
not good. Any ideas out there? I have SP3 for Office and am running Office
2003 on my (sigh) Vista laptop.

Thank you!

Destin Richter
[email protected]
 
A

aaron.kempf

Ubuntu 8 ships next month ;)

I'd reccomend either moving to Access 2007 or Windows XP.. so that you
can run MSDE 2.0.

I haven't had to deal with linked tables, compact and repair; etc-- in
the past decade!! Ask me how!

-Aaron
 
T

Tony Toews [MVP]

Destin Richter said:
Hi. Lately, when I'm running a compact and repair on any of my databases
(new or old), I get a message that Microsoft Access has stopped working. So
not good. Any ideas out there? I have SP3 for Office and am running Office
2003 on my (sigh) Vista laptop.
Click to expand...

On any of your databases? That's interesting. Ah, that could be a
permissions problem on the folder in which the MDBs reside. Do you
have complete read, write and delete privileges?

What happens when you try importing the objects into a new mdb file?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
D

Destin Richter

Tony, I did import the data & structure into a new mdb file, but that hasn't
changed anything. It starting happening a few months ago, and unfortunately
I don't recall any other clues. I may end up removing/reinstalling Access to
see if that helps. I have full permissions - none of that has changed.

Thanks.
 
G

gllincoln

Hi Destin,

You said laptop? How is your hard drive freespace doing? Any issues or
allocations getting in the way? How large are those databases?

I've seen an occasional oddity on compact repair once I cross over the 1 gig
line. Might try copying the database over to another system (if that is an
option) and see if it compacts/repairs there. At a minimum, this would offer
a clue as to whether it's the database or the machine that is failing.

Hope this helps,
Gordon
 
D

Destin Richter

Gordon, size doesn't matter. I have databases under 1 MB, same issue. This
one is 5 MB. I've done all the obvious stuff and it just doesn't work (the
compact & repair function). Plenty of HD space, defragged daily via
Diskeeper. Going to remove/reinstall Access and suspect that may do it.
Thanks for the thoughts.

Destin
 
A

aaron.kempf

warning

this is really t o n y t o e w s

You _DEFINITELY_ shouldn't listen to him because he doesn't know the
pros and cons of any real database systems

god damn kid playing in his sandbox.
and he stalks me.

He's a stupid canuck!
 
Top