Compact & Repair

  • Thread starter Thread starter Roger Bell
  • Start date Start date
R

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
 
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.
 
Roger Bell said:
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.
Click to expand...

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/
 
Back
Top