adding pictures using access 2007

[galanthus]

After three weeks figuring out Access 2003, I have run into the problem of including a large number of pictures (ultimatly in excess of 1000) into my new database. The database; gets too full, Jpegs seem to need changing to bitmap or I need to learn to write code and put the pics on a cd

Today I downloaded the trial version of Access 2007. I can now add pictures as attachments with ease and they even look good on my form!!

My question is, will this new attachment feature solve my problems or will the number of pictures, which I will ultimately include, still cause problems.

Thanks

 

[Moniker]

Don't embed the pictures in your DB. Link them. Otherwise, you're going to make an obtuse and obscenely large DB (especially with 1000s of photos). If you need to distribute this, then distribute the DB along with a folder that contains the pictures and have them installed in the same directory, like this:

C:\YourDB\YourDB.mdb
C:\YourDB\YourPics\pics.jpg (one for each picture)

Then you link each image as in ImageControlName.Location = "C:\YourDB\YourPics\<pic_name_variable>.jpg

Converting a JPG to BMP is going to greatly increase, not decrease its size. Embedding a ton of photos is never a good idea.

 

[galanthus]

Hi Thanks for responding so quickly

So are you saying that the the new attachment feature on Access2007 isn't a solution for this number of pics? Its just I'd read somewhere that it stopped the database "bloating".

I was already linking my jpeg pics using the OLE feature but they were not showing on reports. I got the word "package" in my table which is why I converted them to bitmap.

I'm not sure what I'm doing when it comes to writing code.

sorry for being so dim!!

 

[Anthony George]

I dont know if this will help

Hi
Have a look at this

http://www.access-programmers.co.uk/forums/showthread.php?p=564251#post564251

Regards

Tony