Re: Access project image files
- From: "Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@xxxxxxxxxxxx>
- Date: Sun, 6 Jan 2008 18:04:50 -0400
You're missing the point. Posting to multiple NG's is acceptable as long as
you cross post, not multipost. This was explained to you in detail in one of
your duplicate posts but I cannot remember which NG.
I will not answer a question that is multiposted especially when the OP(you)
insists on not following standard NG Etiquette.
--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"big moose" <bigmoose@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A5CC90A-E1DB-4277-8F11-EA8991C4E2BE@xxxxxxxxxxxxxxxx
I posted to multiple groups since no one seems to know how to handle this
problem. Must I wait for each group to respond before asking another? That
is
not how real business works unfortunately.
I do appreciate your effort to respond and providing some insight into
this
problem. I am aware that an "image" file does not necessarily refer to a
picture but rather a blob generally. My own research would suggest that
these are stored as "byte() arrays" and must be opened somehow with a .net
datareader as a "stream" but so far have not been able to accomplish that.
"Sylvain Lafontaine" wrote:
I hope that you have took notice of all the newsgroups that you have
posted
to.
On SQL-Server, *image* field are not necessary images; the type "image"
is
simply a varbinary of a length that might be greater than 8000 bytes and
the
fact that this type is called "image" doesn't mean that it's associated
with
some special capabilities to display images or other types of documents
like
Word document.
Access has a special type of field that is called OLE Object and that can
be
used to store images and Word documents. When linked to a SQL-Server,
this
field is usually linked to a field of type image. However, it's not
exactly
the image or the document itself that is stored in the database; as
Access
add an header of variable length but usually of length 76 bytes before
the
data of the image or the document itself. Also, I'm not sure if the
length
is 76 bytes, so you will have to make some verification. I'm not sure
also
if the length is always exactly the same length or not. For images, I do
know for sure that this length is constant but for other types of
document,
I don't know.
So, if you want to display these documents in .NET, my thinking is that
you
will have to strip this header and take only the following bytes.
Of course, this is true only if your original ADP application use the
standard way of Access of displaying images and other types of documents.
If this application is using its own method of storing, retrieving and
displaying Word documents; you will to adapt your code, of course.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"big moose" <bigmoose@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:17E64328-F191-4D0A-848D-6D3F4A37C517@xxxxxxxxxxxxxxxx
I have a sql2000 database with a Access 2003 project front end that I am
trying to update to a vb.net front end application. In the access data
project, word documents were inserted into the database as "image"
files.
Does anyone know how to open these in .net? I received a request in
vb.net2008 to import a reference to
"Microsoft.ReportDesigner.Images.ImageControl" but can find nothing
about
this anywhere.
Any suggestions? Thank you in advance.
.
- References:
- Re: Access project image files
- From: Sylvain Lafontaine
- Re: Access project image files
- From: big moose
- Re: Access project image files
- Prev by Date: Re: Access project image files
- Next by Date: Re: Export List box text to txt file
- Previous by thread: Re: Access project image files
- Next by thread: Re: Export List box text to txt file
- Index(es):
Relevant Pages
|
