RE: What Gets Stored When Access Inserts a BLOB?
- From: v-fathan@xxxxxxxxxxxxxxxxxxxx (Mark Han[MSFT])
- Date: Wed, 25 Mar 2009 10:29:39 GMT
Hi Mark,
Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.
From your description, I understand that after you create a talbe in theaccess database, if you insert into a OLE object(PDF file), the data which
is inserted in to the database is much larger the acutally PDF file. and
you would like to know what get stored when access insets a BLOB. If I have
misunderstood, please let me know.
To make sure we are on the same page, I would like to explain the following
1 Access add a header to each binary image before storing it in the
database. This header is of a variable length but it's usually in the
range of 72 to 76 bytes and will usually be of the same length for the same
type of image.
2 I have tried to re-produce the issue; however after I inserted the PDF
file with(1175 KB) and save the accessdatabase, the size of the access
database is just 1400 KB ; so the issue you describe is not able to be
reproduced on my machine. Based on the my test, to better understand the
issue, please help to confirm/collect the following
a) how many OLE Object you have inserted into the database?
b) please send me a simple of the access database file. if possible, please
send me an email; I will create a FTP(workspace) for you to upload the file
requested.
Besides, about the slow performance when insert PDF file into the SQL
Server 2008. As I explained before, the issue might be related to the
scenario.
my test step
create a talbe with 2 column
insert the pdf file by the command. the pdf file is inserted into the SQL
Server database quickly. So to better understand the issue, please describe
the steps you do when re-producing the issue
INSERT INTO access(data) VALUES(0x0)
UPDATE access set data = (SELECT * FROM OPENROWSET(BULK
'E:\01_Engine_Extended Events (XEvent) Fundamentals.pdf', SINGLE_BLOB) AS x
)
If there is anything unclear, please let me know.
I look forward to hearing from you.
Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
.
- Follow-Ups:
- Re: What Gets Stored When Access Inserts a BLOB?
- From: Mark Olbert
- Re: What Gets Stored When Access Inserts a BLOB?
- References:
- What Gets Stored When Access Inserts a BLOB?
- From: Mark Olbert
- What Gets Stored When Access Inserts a BLOB?
- Prev by Date: Re: Incredibly Slow Access Times in Access 2007
- Next by Date: Re: What Gets Stored When Access Inserts a BLOB?
- Previous by thread: Re: What Gets Stored When Access Inserts a BLOB?
- Next by thread: Re: What Gets Stored When Access Inserts a BLOB?
- Index(es):
Relevant Pages
|
