#1
  1. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2003
    Posts
    879
    Rep Power
    12

    Thumbs up saving pic to dbase


    I have been using Access as a database to my program in VB, for sure it can really save data, but is it possible also to save pictures to access? in short how can i save pictures to database?
  2. #2
  3. No Profile Picture
    Average Intelligence
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2003
    Location
    Ohio/Chicago
    Posts
    678
    Rep Power
    12

    my 2 cents


    Access adds a lot of OLE overhead when storing pictures in OLE fields, and this isn't recommended. Use a text field to store a link to the file instead.

    Compacting the database may alleviate the problem somewhat, but it is indeed impractical to store pictures in the database.

IMN logo majestic logo threadwatch logo seochat tools logo