Image Storgage capabilities with SQL SERVER

[James]

I am researching the pros and cons of having images stored with client details.
Using an MsAccess front-end SQL SERVER 7.0
back-end.
Obviously speed is an issue but I not to sure about the possibility.

[C. E. Buttles]

What kind of images? If you are talking about jpeg, gif or other small
files, you are better off putting a pointer to a image directory.
Text/Image columns are stored in 8k pages plus the overhead for the pointers
created in SQL Server. Look in BOL and search on text/image for more
details. What you suggest would be fast enough, but consider the overhead.


"James" <jifill@stratisoft.com> wrote in message
news:38d120c9$1@news.devx.com...
>
> I am researching the pros and cons of having images stored with client
details.
> Using an MsAccess front-end SQL SERVER 7.0
> back-end.
> Obviously speed is an issue but I not to sure about the possibility.