How do I 'unbloat' a DB?

[Newsscanner]

I tried to add a field to an Access DB which would contain a small
picture of every person in the DB.
As I was warned, the DB (with only about 15 records) bloat3ed to a
massive 76 Mb.
I have now deleted the picture field but I am still left with 74.4 Mb.
How can I slim the DB down to a somewhat more normal size?

TIA,
Newsscanner.

 

[Allen Browne]

Through the menus:
Tools | Database Utilities | Compact

 

[John Ortt]

I tried to add a field to an Access DB which would contain a small
picture of every person in the DB.

A html link to the pictures may be a better solution........

 

[Newsscanner]

A html link to the pictures may be a better solution........

I know, tried that, but no luck.
Also saw some good examples of Databases with pictures in it, but don't
understand how to transfer that one field (the picture one) to my db.
Thanks anyway.

 

[Allen Browne]

You can use a Hyperlink field, and display it in an unbound picture control,
using the Current event of the form.

Introduction to hyperlink fields:
http://members.iinet.net.au/~allenbrowne/casu-09.html

Code to display it in Form_Current:
http://www.mvps.org/access/bugs/bugs0044.htm