Pictures in mdb

[Erwin & Chris]

Hello

We want to create a database where we can store an items information with a
picture. Already set up a database where the pictures got embedded in. The
problem that we found is that the size of the database is increasing a lot.
We got around 500 items and 20MB of pictures, the database size grow up to
750MB. Also we read somewhere that access only deals with maximum 1GB mdb
files!? Is this true and the same in 2007?

Does anybody got a good idea to work around this problem? At the moment the
db is setup so we can drag and drop the pictures from windows explorer into
the database.

Kind regards
Erwin

 

[Fred]

I heard that Access 2007 fixed the problem but I can't speak for that.

For certain everything up through 2003 has explosive bloat when you embed.
Dale's idea is the answer.

As far as using them, (viewing them, making the show up in forms, report
etc.) there are several ways that were covered in the "database design" or
"Programming" or"General" section of this Access discussion group on 2007 and
2008.