How to clean up the "ghost" of the deleted records?

's Computer Specifications

I deleted lots of records from the database. However, I found that the size
of the database is same as before which make the database very large and
slow. How to clean up the space used up by the ghost of the deleted records?
Thanks in advance for your suggestion and help.

's Computer Specifications

You can try Tools > Database Utilities > Compact and Repair...

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html

"YSong" <(E-Mail Removed)> wrote in message
news:B2C5EE26-2C1B-465C-BB19-(E-Mail Removed)...
>I deleted lots of records from the database. However, I found that the size
> of the database is same as before which make the database very large and
> slow. How to clean up the space used up by the ghost of the deleted
> records?
> Thanks in advance for your suggestion and help.

's Computer Specifications

YSong wrote:
> I deleted lots of records from the database. However, I found that
> the size of the database is same as before which make the database
> very large and slow. How to clean up the space used up by the ghost
> of the deleted records? Thanks in advance for your suggestion and
> help.

Tools - Database Utilities - Compact/Repair

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

's Computer Specifications

Thanks. Already done. It works.

"Lynn Trapp" wrote:

> You can try Tools > Database Utilities > Compact and Repair...
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Access Junkie List:
> http://home.bendbroadband.com/conrad...essjunkie.html
>
>
>
> "YSong" <(E-Mail Removed)> wrote in message
> news:B2C5EE26-2C1B-465C-BB19-(E-Mail Removed)...
> >I deleted lots of records from the database. However, I found that the size
> > of the database is same as before which make the database very large and
> > slow. How to clean up the space used up by the ghost of the deleted
> > records?
> > Thanks in advance for your suggestion and help.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PC boots to black screen. How to reinstall Vista ("upgrade", not "clean" install)	Marvin Hlavac	Windows Vista Installation	7	16th Nov 2008 01:23 AM
Utility to "clean up" or "defrag" large Excel file	=?Utf-8?B?U2FicmluYQ==?=	Microsoft Excel Misc	3	12th Jan 2006 09:57 PM
URGENT HELP!! Can recover deleted files after use "clean up "utili	=?Utf-8?B?SG9zZWlu?=	Windows XP Setup	1	17th Jun 2005 03:44 AM
Set up "Clean" User or "Clean" boot for max memory for video editi	=?Utf-8?B?bWltaQ==?=	Windows XP Setup	1	13th Feb 2005 12:30 AM
records show "deleted"	Josh	Microsoft Access Forms	7	24th Dec 2003 11:58 PM