WenYuan,
I created a sample Access database, I then inserted 5 different .jpg
pictures into the OLE Object field for a total of 5 records. Looking at my
code from my first post, I created a 'MediaType' field and set the values to
'Mug shot'. I also made sure that the OLE Object field was the 4th field
defined in my table. I also named the table 'tblMedia' since that is what the
code is referring to.
I ran my code against the new sample database and I received the same error
('Parameter is not valid.')
If you want I could e-mail you the sample database and my code but you could
very easily reproduce the error just like I did.
If you want me to e-mail you my stuff, please give me an alternate e-mail
address. I've already tried to email you at 'v-wywang@online.microsoft.com'.
Outlook gives me this error message:
Your message did not reach some or all of the intended recipients.
Subject: Test Message
Sent: 12/13/2007 9:28 AM
The following recipient(s) could not be reached:
v-wywang@online.microsoft.com on 12/13/2007 9:28 AM
The message could not be delivered because the recipient's
destination email system is unknown or invalid.

Signature
Dave B.
David.M.Busovicki@usdoj.gov
(814) 532-4925
> Hello Dave,
> Thanks for your reply.
[quoted text clipped - 15 lines]
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
WenYuan Wang [MSFT] - 14 Dec 2007 10:54 GMT
Hello Dave,
Thanks for your reply,
It seems you send the mail to a wrong address.
> My alias is v-wywang@microsoft.com. I'm waiting for your reply.
As we discussed before, you can get me at v-wywang@microsoft.com.
I created an Access DB, and insert some jpeg images into it. Finally, I
reproduced it.
After research, I found 78 byte is used for BMP image. It doesn't work fine
with JPEG image file. Under my test, the offset for JPEG image is 189.but
I'm not sure. It seems the number dependens on the size of file.I need
perform further research.
Is it possible for you to give me your email Address? Thereby, I can pass
the information for you as soon as possible.(again, my alias is
v-wywang@microsoft.com. You can send an email to me.) If you have any more
concern, please also feel free to update here. We are glad to assist you.
Have a great day.
Best regards,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Marc - 07 Mar 2008 06:19 GMT
WenYuan,
I have the same problem that is 'parameter not valid'. Do you have any
developments on the offset value for JPEG images? How do you determine if the
offset value is 189 or something else?
Cheers,
Marc