AdrenalineX Forums

General => Off-Topic => Topic started by: [2F2F]Steven8 on February 15, 2009, 05:36:06 pm

Title: Access 2007
Post by: [2F2F]Steven8 on February 15, 2009, 05:36:06 pm

Does anyone knows how to add photo to database in access 2007 ?

Title: Re: Access 2007
Post by: [LSR]Jalicno on February 15, 2009, 09:25:54 pm

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.

Title: Re: Access 2007
Post by: [2F2F]Steven8 on February 17, 2009, 06:47:48 am

lol thx  :)