Dbase size

N

Naguib Sami

my dbase has reached the size of 17 megabite, it became
very heavy and I wonder if someone can advise and help to
solve the oversized application, how and where I went
wrong.
 
R

Robert Blackwell

I know my dbase expands a few MB now and then,

In access, if you click on the menu: tools>database utilities>compact and
repair

This might reduce the file size by a couple megs. backup before you do
though.

I do this every couple of days or so
 
A

Arvin Meyer

Naguib Sami said:
my dbase has reached the size of 17 megabite, it became
very heavy and I wonder if someone can advise and help to
solve the oversized application, how and where I went
wrong.
Click to expand...

Have you tried compacting it?

Tools ... Database Utilities ... Compact and Repair

A well designed Access database can be several hundreds of MBs before it
appreciably slows down.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top