Saving Image in MS Access database

Saving Image in MS Access database

Page 1 of 1

3 Replies - 15157 Views - Last Post: 10 July 2007 - 02:23 PM

#1 dragonflyz  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 29-June 07

Saving Image in MS Access database

Post icon  Posted 29 June 2007 - 09:32 PM

Please help me to code on how save an image to ms access database...
Is This A Good Question/Topic? 0
  • +

Replies To: Saving Image in MS Access database

#2 fyrestorm  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 10
  • View blog
  • Posts: 3,113
  • Joined: 04-April 02

Re: Saving Image in MS Access database

Posted 01 July 2007 - 09:44 AM

since you've given us very limited information on what you're trying to accomplish, let me direct you to this thread

Saving Images in MS Access and MS SQL Server 7
Was This Post Helpful? 0
  • +
  • -

#3 kenham40  Icon User is offline

  • New D.I.C Head

Reputation: 3
  • View blog
  • Posts: 14
  • Joined: 22-June 07

Re: Saving Image in MS Access database

Posted 06 July 2007 - 06:00 PM

View Postdragonflyz, on 29 Jun, 2007 - 09:32 PM, said:

Please help me to code on how save an image to ms access database...


If you don't mind me asking, why don't you just save the paths in the Access DB (keeping the size down), and then call the path to the image instead of the actual image?
Was This Post Helpful? 1

#4 Gadjet  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 2
  • Joined: 10-July 07

Re: Saving Image in MS Access database

Posted 10 July 2007 - 02:23 PM

View Postdragonflyz, on 29 Jun, 2007 - 09:32 PM, said:

Please help me to code on how save an image to ms access database...


I've found that storing images within the access database is not a good idea, I think that MS Access always converts the image to a bmp format that its quite big so if you add a 50k jpeg image it can increase your database file by say 1MB 'ish.

I stored the images in a sub folder and store a link to them within the database, I'm not sure but I think you can view them within the form even if they are stored outside the database.

Hope that helps.

Gadjet
Was This Post Helpful? 1

Page 1 of 1