deleting Access records does not reduce overall file size

B

Bekkilin

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!
 
N

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
 
V

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.
 
N

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
----
 
N

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
 
N

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