Results 1 to 2 of 2

Thread: insert images

  1. #1
    Join Date
    May 2002

    Unanswered: insert images

    Would you please show me how to create a table in Microsoft Access that can contains images. Also, please show me one SQL statement that will select and display images to the screen using ASP. Thank you very much.

  2. #2
    Join Date
    May 2002
    Atlanta, GA
    I can't answer the ASP part of your question, but if you want to create a table using visual basic that will contain images, here is the code:

    Dim db as Database
    Set db = Currentdb
    db.Execute "CREATE TABLE TableName (SomeField OLEOBJECT);"

    Or you can go into the Table Design portion of access and create a new table with a field that has its Data Type set to OLE Object. Than choose Insert, Object from your menu to insert images.

    Hope this helps you!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts