deleting Access records does not reduce overall file size

[Guest]

I have a 55 MB Access db that I needed to "empty out" to give to a friend. I
copied the file, renamed, deleted all table records and saved. The file is
still 55 MB - why? I need to email my empty db to my friend and it won't go
like this! Help!

 

[Roger Carlson]

From the Database Window, choose: Tools > Database Utilities > Compact and
Repair. This will compact the database, removing the empty space. Deleting
alone will not do this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Niklas Östergren]

Bekkilin

Which version of Access do you use? If it´s older version than A2000, I
think, then you need to compact and repaire it manually by selecting
<Tool> - <DatabaseTool> - <Compacting & Repair>. But if it´s a newer version
it should compact and repair automaticly every time you close the db.

My 5 cent´s of knowledge.

// Niklas

 

[Van T. Dinh]

Most database engines do not automatically recover the storage space when
you delete data.

In Access, you need to use the Compact and Repair command to recover the
storage space.

 

[Nick Coe \(UK\)]

Compact on Close is an overall option not something that
happens by default.

IIRC you'll find it in Tools|Options|General.

--
Nick Coe (UK)
AccHelp v1.01 Application Help File Builder
http://www.alphacos.co.uk/
Download Free Demo Copy
----

 

[Niklas Östergren]

OK, then I have learnt something new, thanks!

On the other hand isn´t that option by default set after the installation of
Access application? It seams to on my pc anyway.

// Niklas

 

[Nick Coe \(UK\)]

It certainly could be. I don't remember. I haven't had to
install or re-install for quite a while.

--
Nick Coe (UK)
AccHelp v1.01 Application Help File Builder
http://www.alphacos.co.uk/
Download Free Demo Copy
----