Saving Pictures in MSAccess Database

Discussion in 'Visual Basic ( VB )' started by BrokenSyn, Aug 5, 2007.

  1. BrokenSyn

    BrokenSyn New Member

    Joined:
    May 7, 2007
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    0
    anyone got a codes for Browsing Pictures in Files to Visual Basic 6 and Store it or Save it in Microsoft Access Database. And then Retrive it in Viusal Basic 6.0

    thnx


    ___________
    H0axility :D
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,376
    Likes Received:
    388
    Trophy Points:
    83
    I have done that some time back but could not get the hands on the code but I wil try to recall.

    I had some binary data fields in the database and then used to read the file in the variant and then dump that data into the database.

    When retrieveing I just copied the data into the temp file and showed it in the picture box.
     
  3. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,376
    Likes Received:
    388
    Trophy Points:
    83
    Also I just realized you are using the signature in the post but you can use it by visiting the My Go4Expert link In case you did not know that.
     
  4. jwshepherd

    jwshepherd New Member

    Joined:
    Aug 13, 2007
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    VP Technology Corporation
    Location:
    Texas
    Home Page:
    http://www.officialhackers.com
    depending on how many you are planning to store it actually makes more sense to just store the path to the files. once an Access database gets larger than 1Gb it starts getting slow and at 2GB it may become corrupted.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice