Database Size

[Guest]

I am creating a new database and it is already almost 4MB in size. The
database isn't that big yet and has only a little bit of data in it. It has
a couple of pictures in it from clip art but those are only a few KB. I even
deleted the pictures ran a compact and the size barely changed. I have......

14 Tables
4 Queries
11 Forms

Any one know why it could be getting so big already?

 

[Lynn Trapp]

Storing pictures in your database can cause the database to bloat quite a
bit. You should simply store the path to the image file and display it when
you need it through code.

 

[Joseph Meehan]

In addition to what Lynn wrote, Access Databases, like many others, does
not delete data when you "delete" it, it only hides it. You need to compact
the database to recover the space.

BTW 4MB is a small database, you can go to at least 1 gig.