compact and repair

[NES]

Hi...I HOPE someone can answer my question. I have ACCESS 2000 and I
recently "compact & repair" and my databse is working much faster. I set up
another person with my ACCESS database and they have a later version of
ACCESS but she does not have a "tool" icon at the top of screen. She can not
seem to find the "DATABASE UTILITIES" within the databse to perform the
"compact & repair".

Can anyone HELP ME?

 

[tedmi]

Office button (round yellow one at upper left), Manage

 

[NES]

Thank you!

 

[Elizabeth]

Our office recently installed office 2007. I am having problems getting my
Access database to compact. I work off of a home drive from a server. I post
data changes to a shared drive on the server and back it up on a thumbdrive.
I have tried using Manage/compact repair when working in the database from
the server. I have also set the options to compact repair on close. The
database does not compact. If I copy it to the thumbdrive it does compact. I
have been copying it to the thumbdrive and then recopying it back to the
server drives. Can you help? Thanks!

 

[Douglas J. Steele]

What happens when you try to compact? Do you get an error message? If so,
what's the error? If you don't get an error, why do you think it's not
working?

 

[Elizabeth]

Doug. I do not get an error message. My computer seems to take some time to
process something, like it is compacting. I do not think it is working
because when I go to the directory and look at the file size, there is no
change--still bloated file count. This is after opening and closing. When I
do the same thing after posting to a thumbdrive/opening & closing/ the size
of the thumbdrive shrinks considerably; and when I post the thumbdrive files
back to the 2 server drives, the file size changes to the shrunken number.
Thanks for any help you can give.

 

[Douglas J. Steele]

Afraid I haven't seen that before, but realistically there's nothing wrong
with copying the file locally in order to compact it. There's always a
chance of corruption compacting on the LAN.