Compact & Repair

[Roger Bell]

Could someone please advise me how to Compact & Repair a Data Base n Access
2007. I understand there is a Bug and you can lose your Data Base completely.
Thanks for any help

 

[Chris]

Compact and Repair as explain to me, is a way of defraging you Dbase. if you
go to the properties of your Dbase and look at the actual size, lets say for
example it is 508mb, go to tools>database utilities>compact & repair and
select. Now go back to your properties of your DBase and you will see the
files were compress, and your files should be compress to a small size. As
far as repairing the Dbase, I am sure if that has anything to do with
debugging. But from what I understand, it wont hurt to frequently utilize
this tool.

 

[Tony Toews [MVP]]

Could someone please advise me how to Compact & Repair a Data Base n Access
2007. I understand there is a Bug and you can lose your Data Base completely.

There is a hotfix which solves that problem.
http://support.microsoft.com/kb/950812

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/