Professional Web Applications Themes

MS Access vs MySQL - Dreamweaver AppDev

I am using MS Access 2002. One of the field of my table in the database require to store images. I am realizing, please correct me if I am wrong, that I can use only .btm or .psd (photoshop) files as the sources for the images. Basically if I pass a .jpg or .gif image I am going to get an error, as it happens using <CFINSERT> at the moment. So the question is: Will MySQL a better choice than MS Acess 2002 in order to store and retreive images like ..jpg and .gif? Thank you, Dario...

  1. #1

    Default MS Access vs MySQL

    I am using MS Access 2002. One of the field of my table in the database require
    to store images. I am realizing, please correct me if I am wrong, that I can
    use only .btm or .psd (photoshop) files as the sources for the images.
    Basically if I pass a .jpg or .gif image I am going to get an error, as it
    happens using <CFINSERT> at the moment. So the question is: Will MySQL a
    better choice than MS Acess 2002 in order to store and retreive images like
    ..jpg and .gif? Thank you, Dario

    xcoldnet Guest

  2. #2

    Default MS Access vs MySQL

    I am using MS Access 2002. One of the field of my table in the database require
    to store images. I am realizing, please correct me if I am wrong, that I can
    use only .btm or .psd (photoshop) files as the sources for the images.
    Basically if I pass a .jpg or .gif image I am going to get an error, as it
    happens using <CFINSERT> at the moment. So the question is: MySQL will be a
    better choice than MS Acess 2002, in order to store and retreive images like
    ..jpg and .gif? or not. Thank you, Dario

    xcoldnet Guest

  3. #3

    Default Re: MS Access vs MySQL

    You are incorrect. A binary file is a binary file, and Access should store
    jpeg, gif, pdf, or anything else you put into a binary field. The problem
    is making sure it's read correctly when it's pulled out. Since I never
    store files and only store the file paths in my database, I can't be of any
    other help than to say you can certainly store what you want. It must be
    some other problem.

    "xcoldnet" <webforumsusermacromedia.com> wrote in message
    news:cvl1cp$31k$1forums.macromedia.com...
    > I am using MS Access 2002. One of the field of my table in the database
    require
    > to store images. I am realizing, please correct me if I am wrong, that I
    can
    > use only .btm or .psd (photoshop) files as the sources for the images.
    > Basically if I pass a .jpg or .gif image I am going to get an error, as it
    > happens using <CFINSERT> at the moment. So the question is: Will MySQL a
    > better choice than MS Acess 2002 in order to store and retreive images
    like
    > .jpg and .gif? Thank you, Dario
    >

    CMBergin Guest

  4. #4

    Default Re: MS Access vs MySQL

    sorry, not an answer just to ask, why do you store the images in the DB?
    I think the best approach is to store just the file names in the DB
    & the images in a folder

    manuel

    xcoldnet wrote:
    > I am using MS Access 2002. One of the field of my table in the database require
    > to store images. I am realizing, please correct me if I am wrong, that I can
    > use only .btm or .psd (photoshop) files as the sources for the images.
    > Basically if I pass a .jpg or .gif image I am going to get an error, as it
    > happens using <CFINSERT> at the moment. So the question is: Will MySQL a
    > better choice than MS Acess 2002 in order to store and retreive images like
    > .jpg and .gif? Thank you, Dario
    >
    Manuel Socarras Guest

Similar Threads

  1. Access does not like Mysql
    By Stuart McGraw in forum MySQL
    Replies: 3
    Last Post: December 2nd, 08:47 PM
  2. Access to mySQL db
    By IPT in forum ASP Database
    Replies: 3
    Last Post: June 22nd, 05:39 AM
  3. MySQL to Access!
    By janet in forum ASP Database
    Replies: 1
    Last Post: August 28th, 02:08 AM
  4. ms access to MYSQL
    By manjunatha in forum ASP Database
    Replies: 1
    Last Post: July 22nd, 10:00 PM
  5. MySQL vs. Access
    By Jordan Marton in forum Macromedia Dreamweaver
    Replies: 5
    Last Post: July 16th, 10:00 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139