Compact the database problem

[barbara_dave]

Hi, All,

I have an existing access database. It can't be added more data and
its size is 32mb. I wonder it is full. I use access utilities to repair
and compact it, but I got error message "Microsoft Office Access has
encountered a problem and needs to close."

What cause the Access stop compacting the database? Please give me some
instructions?
Thanks a lot in advance!

[Barry Wright]

Hi,

It sounds like you have a corrupt database. You can try to decompile the
database by adding the "/decompile" (without quotes) switch to the startup
command line. After the decompile, remove the /decompile switch and compact
the database a couple of times then run the form again. This has always
worked for me!

However, if the decompile trick above does not work you can make an enpty
database and then using the File\Get External Data\Import option from the
Access Menu, import all of the objects (don't forget to import any menus you
have created) from the corrupt database.

Regards,
Barry


<ba**********@yahoo.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Hi, All,

I have an existing access database. It can't be added more data and
its size is 32mb. I wonder it is full. I use access utilities to repair
and compact it, but I got error message "Microsoft Office Access has
encountered a problem and needs to close."

What cause the Access stop compacting the database? Please give me some
instructions?
Thanks a lot in advance!

[Tony Toews]

ba**********@yahoo.com wrote:

I have an existing access database. It can't be added more data and
its size is 32mb. I wonder it is full.
No, it's not full. A client has a 300 Mb data mdb.
I use access utilities to repair
and compact it, but I got error message "Microsoft Office Access has
encountered a problem and needs to close."

What cause the Access stop compacting the database? Please give me some
instructions?

You can try the Jetcomp utility.

For more information on corruption including possible causes, determining the
offending PC, retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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