Author Topic: Access 2007  (Read 3092 times)

0 Members and 1 Guest are viewing this topic.

Offline [2F2F]Steven8

  • Admin
  • Posts: 589
  • Learn to see me as a brother.
    • View Profile
Access 2007
« on: February 15, 2009, 05:36:06 pm »
Does anyone knows how to add photo to database in access 2007 ?

Offline [LSR]Jalicno

  • Admin
  • Posts: 12,384
    • View Profile
Re: Access 2007
« Reply #1 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.

Offline [2F2F]Steven8

  • Admin
  • Posts: 589
  • Learn to see me as a brother.
    • View Profile
Re: Access 2007
« Reply #2 on: February 17, 2009, 06:47:48 am »
lol thx  :)