Access 2003 Compact & Repair Crash

[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
(e-mail address removed)

 

[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

 

[Tony Toews [MVP]]

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.

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/

 

[roccogrand]

Is it true that Microsoft will discontinue selling Windows XP in three months?

 

[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.

 

[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

 

[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

 

[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!