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

 

[Dale Fye]

Generally, it is best to store the pictures in a folder on your hard drive or
network, and only store the files full path and name in the database. This
does have a risk that a file will be moved or deleted from where it was
stored, but you can do cleanup work in the database that will identify
missing files.

I think the latest couple of versions let you go to 2Gb.

HTH
Dale

 

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