Blob offset

[Sylvie Bedard]

How can i get the Blob offset ?

[Frank]

Sylvie,

From documentation. Each one is different. You'll prefer to have one that has no offset. When an offset is present then it means it is customized for others like Borlands's Paradox's BLOB has 8 bytes offset. What is yur reason for using embedded BLOBS rather then storing the BLOB's file name.

Frank

On 1/8/99 10:59:36 AM, Sylvie Bedard wrote:
> How can i get the Blob offset ?

[Fred Derf]

The docs aren't very clear on this: I need the offset in Access for JPGs. The docs say the BMP is 78 but what about JPGs?

By the way, it's not my DB structure, so it's not my choice about storing BLOBs.

--Fred

------------
Frank at 1/8/99 10:48:22 PM

Sylvie,

From documentation. Each one is different. You'll prefer to have one that has no offset. When an offset is present then it means it is customized for others like Borlands's Paradox's BLOB has 8 bytes offset. What is yur reason for using embedded BLOBS rather then storing the BLOB's file name.

Frank

On 1/8/99 10:59:36 AM, Sylvie Bedard wrote:
> How can i get the Blob offset ?

[John]

Hi Fred,

Access doesn't store JPGs well, only as OLE objects. According to the
experts at Microsoft, storing BLOBS in an Access database is paramount to
suicide! They STRONGLY recommend against it. They say that if you have to
do this, you should use SQL Server. However, the recommended solution is
to store the filename only in a text field, and HREF it (with MagicCell for
example). That's how we do all the image database examples on our website.

Check out: http://www.aspdb.com/examples/ then click on C1 and C2.

That ought to help. Thanks,
John

------------
Fred Derf at 1/21/00 10:57:49 PM

The docs aren't very clear on this: I need the offset in Access for JPGs. The docs say the BMP is 78 but what about JPGs?

By the way, it's not my DB structure, so it's not my choice about storing BLOBs.

--Fred

------------
Frank at 1/8/99 10:48:22 PM

Sylvie,

From documentation. Each one is different. You'll prefer to have one that has no offset. When an offset is present then it means it is customized for others like Borlands's Paradox's BLOB has 8 bytes offset. What is yur reason for using embedded BLOBS rather then storing the BLOB's file name.

Frank

On 1/8/99 10:59:36 AM, Sylvie Bedard wrote:
> How can i get the Blob offset ?

[Fred Derf]

Thanks for the info, and I would do it this way if I could. The problem is, I am trying to get at the BLOBs (OLE objects) in a DB that is built and maintained by vendor. I have no control over how the images are stored, I'm just trying to retrive them.

So it sounds like the short answer is that it can't be done with Access.

--Fred


------------
John at 1/22/00 4:33:41 AM


Hi Fred,

Access doesn't store JPGs well, only as OLE objects. According to the
experts at Microsoft, storing BLOBS in an Access database is paramount to
suicide! They STRONGLY recommend against it. They say that if you have to
do this, you should use SQL Server. However, the recommended solution is
to store the filename only in a text field, and HREF it (with MagicCell for
example). That's how we do all the image database examples on our website.

Check out: http://www.aspdb.com/examples/ then click on C1 and C2.

That ought to help. Thanks,
John

------------
Fred Derf at 1/21/00 10:57:49 PM

The docs aren't very clear on this: I need the offset in Access for JPGs. The docs say the BMP is 78 but what about JPGs?

By the way, it's not my DB structure, so it's not my choice about storing BLOBs.

--Fred

------------
Frank at 1/8/99 10:48:22 PM

Sylvie,

From documentation. Each one is different. You'll prefer to have one that has no offset. When an offset is present then it means it is customized for others like Borlands's Paradox's BLOB has 8 bytes offset. What is yur reason for using embedded BLOBS rather then storing the BLOB's file name.

Frank

On 1/8/99 10:59:36 AM, Sylvie Bedard wrote:
> How can i get the Blob offset ?

[Frank]

Fred,

Overall, doing BLOBs in Access is a suicide attempt !!
Doing BLOBs in any DB is at least not a good idea and you have to justify it with good reasons like Security adn third part data source etc.. When you move databse records, the BLOBs move with it.


Frank


------------
Fred Derf at 1/22/00 9:32:47 PM

Thanks for the info, and I would do it this way if I could. The problem is, I am trying to get at the BLOBs (OLE objects) in a DB that is built and maintained by vendor. I have no control over how the images are stored, I'm just trying to retrive them.

So it sounds like the short answer is that it can't be done with Access.

--Fred


------------
John at 1/22/00 4:33:41 AM


Hi Fred,

Access doesn't store JPGs well, only as OLE objects. According to the
experts at Microsoft, storing BLOBS in an Access database is paramount to
suicide! They STRONGLY recommend against it. They say that if you have to
do this, you should use SQL Server. However, the recommended solution is
to store the filename only in a text field, and HREF it (with MagicCell for
example). That's how we do all the image database examples on our website.

Check out: http://www.aspdb.com/examples/ then click on C1 and C2.

That ought to help. Thanks,
John

------------
Fred Derf at 1/21/00 10:57:49 PM

The docs aren't very clear on this: I need the offset in Access for JPGs. The docs say the BMP is 78 but what about JPGs?

By the way, it's not my DB structure, so it's not my choice about storing BLOBs.

--Fred

------------
Frank at 1/8/99 10:48:22 PM

Sylvie,

From documentation. Each one is different. You'll prefer to have one that has no offset. When an offset is present then it means it is customized for others like Borlands's Paradox's BLOB has 8 bytes offset. What is yur reason for using embedded BLOBS rather then storing the BLOB's file name.

Frank

On 1/8/99 10:59:36 AM, Sylvie Bedard wrote:
> How can i get the Blob offset ?