Images in SQL

[Paradigm]

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

 

[Arvin Meyer [MVP]]

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]

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]]

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]

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