Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Images in SQL

Discussion in 'Information Technology' started by Paradigm, Jul 28, 2006.

Tags:
  1. Paradigm

    Paradigm
    Expand Collapse
    Guest

    I use an Access 2K front end to an MSSQL database.
    I want to store some images in an sql table. The reason for this is that the
    images are scanned signatures and I do not want to just have links to the
    paths of the images since users could browse for them. I think keeping them
    in the database would be more secure.

    What field type do I need to store the image
    How do I put the image into the field
    How do I retrieve it from the field

    Some help on the VBA coding would be very much appreciated.
    Thanks
    Alec
     
  2. Loading...

    Similar Threads Forum Date
    1984 Images Revisited - YouTube History of Sikhism Nov 2, 2016
    He’s The World’s Best Water Photographer… And He’s Just Released These Haunting Images. Sikh Sikhi Sikhism Aug 30, 2015
    Nature Caterpillars Morph into Butterflies in Amazing 3D Images Breaking News May 15, 2013
    SciTech Rare images beyond the naked eye Breaking News Oct 23, 2010
    Heritage Old Paintings and Images of Lahore (British Library Collection) History of Sikhism Sep 29, 2010

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    I've been using SQL-Server 2005 for the past year and there is a native
    image datatype. I can't remember whether earlier versions have it or not
    since I don't store images in the database. There may be an OLE field, and
    that's where you'd store them. As far as security of links, you simply need
    to have a secure folder for each person and limit access to only those who
    are allowed to each one. That's not only easier, but more secure since once
    that person is terminated you only need to disable his/her account in 1
    place.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Paradigm" <alecjames1@hotmail.com> wrote in message
    news:nYspg.7782$eQ.2875@newsfe7-win.ntli.net...
    >I use an Access 2K front end to an MSSQL database.
    > I want to store some images in an sql table. The reason for this is that
    > the
    > images are scanned signatures and I do not want to just have links to the
    > paths of the images since users could browse for them. I think keeping
    > them
    > in the database would be more secure.
    >
    > What field type do I need to store the image
    > How do I put the image into the field
    > How do I retrieve it from the field
    >
    > Some help on the VBA coding would be very much appreciated.
    > Thanks
    > Alec
    >
    >
     
  4. Paradigm

    Paradigm
    Expand Collapse
    Guest

    The sort of people I deal with don't understand computer issues and rely on
    others to set up and configure their systems for them. They are concerned
    that these 'others' will have access to the files and nothing can convince
    them otherwise.
    Alec

    "Arvin Meyer [MVP]" <a@m.com> wrote in message
    news:uSzKrARnGHA.376@TK2MSFTNGP05.phx.gbl...
    > I've been using SQL-Server 2005 for the past year and there is a native
    > image datatype. I can't remember whether earlier versions have it or not
    > since I don't store images in the database. There may be an OLE field, and
    > that's where you'd store them. As far as security of links, you simply

    need
    > to have a secure folder for each person and limit access to only those who
    > are allowed to each one. That's not only easier, but more secure since

    once
    > that person is terminated you only need to disable his/her account in 1
    > place.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "Paradigm" <alecjames1@hotmail.com> wrote in message
    > news:nYspg.7782$eQ.2875@newsfe7-win.ntli.net...
    > >I use an Access 2K front end to an MSSQL database.
    > > I want to store some images in an sql table. The reason for this is that
    > > the
    > > images are scanned signatures and I do not want to just have links to

    the
    > > paths of the images since users could browse for them. I think keeping
    > > them
    > > in the database would be more secure.
    > >
    > > What field type do I need to store the image
    > > How do I put the image into the field
    > > How do I retrieve it from the field
    > >
    > > Some help on the VBA coding would be very much appreciated.
    > > Thanks
    > > Alec
    > >
    > >

    >
    >
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Sure, it is easy to convince them. Set up a secure folder that only you have
    access to on the server. Put a text file in it. Offer them $10 if they can
    open or copy that file. The fact is, that anyone who has the ability to
    crack into the server, can probably also crack into SQL-Server. In any case,
    once the document is printed with a signiture on it, that signature can be
    copied and a new file created. If they think that they are totally safe by
    securing any file, they are sadly mistaken.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Paradigm" <alecjames1@hotmail.com> wrote in message
    news:tpvpg.76114$uP.21891@newsfe2-gui.ntli.net...
    > The sort of people I deal with don't understand computer issues and rely
    > on
    > others to set up and configure their systems for them. They are concerned
    > that these 'others' will have access to the files and nothing can convince
    > them otherwise.
    > Alec
    >
    > "Arvin Meyer [MVP]" <a@m.com> wrote in message
    > news:uSzKrARnGHA.376@TK2MSFTNGP05.phx.gbl...
    >> I've been using SQL-Server 2005 for the past year and there is a native
    >> image datatype. I can't remember whether earlier versions have it or not
    >> since I don't store images in the database. There may be an OLE field,
    >> and
    >> that's where you'd store them. As far as security of links, you simply

    > need
    >> to have a secure folder for each person and limit access to only those
    >> who
    >> are allowed to each one. That's not only easier, but more secure since

    > once
    >> that person is terminated you only need to disable his/her account in 1
    >> place.
    >> --
    >> Arvin Meyer, MCP, MVP
    >> Microsoft Access
    >> Free Access downloads
    >> http://www.datastrat.com
    >> http://www.mvps.org/access
    >>
    >> "Paradigm" <alecjames1@hotmail.com> wrote in message
    >> news:nYspg.7782$eQ.2875@newsfe7-win.ntli.net...
    >> >I use an Access 2K front end to an MSSQL database.
    >> > I want to store some images in an sql table. The reason for this is
    >> > that
    >> > the
    >> > images are scanned signatures and I do not want to just have links to

    > the
    >> > paths of the images since users could browse for them. I think keeping
    >> > them
    >> > in the database would be more secure.
    >> >
    >> > What field type do I need to store the image
    >> > How do I put the image into the field
    >> > How do I retrieve it from the field
    >> >
    >> > Some help on the VBA coding would be very much appreciated.
    >> > Thanks
    >> > Alec
    >> >
    >> >

    >>
    >>

    >
    >
     
  6. paradigm

    paradigm
    Expand Collapse
    Guest

    It will not be me that installs it. As I said they will want their IT
    support to install it and they will have to have access and their own
    internal limited support people will need to know all the passwords for
    maintenance etc.
    Alec

    "Arvin Meyer [MVP]" <a@m.com> wrote in message
    news:%238CWJ7RnGHA.3580@TK2MSFTNGP03.phx.gbl...
    > Sure, it is easy to convince them. Set up a secure folder that only you
    > have access to on the server. Put a text file in it. Offer them $10 if
    > they can open or copy that file. The fact is, that anyone who has the
    > ability to crack into the server, can probably also crack into SQL-Server.
    > In any case, once the document is printed with a signiture on it, that
    > signature can be copied and a new file created. If they think that they
    > are totally safe by securing any file, they are sadly mistaken.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "Paradigm" <alecjames1@hotmail.com> wrote in message
    > news:tpvpg.76114$uP.21891@newsfe2-gui.ntli.net...
    >> The sort of people I deal with don't understand computer issues and rely
    >> on
    >> others to set up and configure their systems for them. They are concerned
    >> that these 'others' will have access to the files and nothing can
    >> convince
    >> them otherwise.
    >> Alec
    >>
    >> "Arvin Meyer [MVP]" <a@m.com> wrote in message
    >> news:uSzKrARnGHA.376@TK2MSFTNGP05.phx.gbl...
    >>> I've been using SQL-Server 2005 for the past year and there is a native
    >>> image datatype. I can't remember whether earlier versions have it or not
    >>> since I don't store images in the database. There may be an OLE field,
    >>> and
    >>> that's where you'd store them. As far as security of links, you simply

    >> need
    >>> to have a secure folder for each person and limit access to only those
    >>> who
    >>> are allowed to each one. That's not only easier, but more secure since

    >> once
    >>> that person is terminated you only need to disable his/her account in 1
    >>> place.
    >>> --
    >>> Arvin Meyer, MCP, MVP
    >>> Microsoft Access
    >>> Free Access downloads
    >>> http://www.datastrat.com
    >>> http://www.mvps.org/access
    >>>
    >>> "Paradigm" <alecjames1@hotmail.com> wrote in message
    >>> news:nYspg.7782$eQ.2875@newsfe7-win.ntli.net...
    >>> >I use an Access 2K front end to an MSSQL database.
    >>> > I want to store some images in an sql table. The reason for this is
    >>> > that
    >>> > the
    >>> > images are scanned signatures and I do not want to just have links to

    >> the
    >>> > paths of the images since users could browse for them. I think keeping
    >>> > them
    >>> > in the database would be more secure.
    >>> >
    >>> > What field type do I need to store the image
    >>> > How do I put the image into the field
    >>> > How do I retrieve it from the field
    >>> >
    >>> > Some help on the VBA coding would be very much appreciated.
    >>> > Thanks
    >>> > Alec
    >>> >
    >>> >
    >>>
    >>>

    >>
    >>

    >
    >
     

Share This Page