Jpgs in a field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mart - 20 Apr 2006 09:09 GMT

I have a database (Access 2000) of books and am wanting to include a picture
of the books cover in one field. How would I do this ie. field type etc.
Also - I am using Frontpage 2003 do display results from this DB. Can anyone
tell me how I would go about displaying the jpgs (I am already displaying
various other fields from the DB).

TIA
Mart

Reply to this Message

NetworkTrade - 20 Apr 2006 20:05 GMT

in general you might explore the Linking Object & Embedding OLE field
type......

Signature

NTC

> I have a database (Access 2000) of books and am wanting to include a picture
> of the books cover in one field. How would I do this ie. field type etc.
[quoted text clipped - 4 lines]
> TIA
> Mart

Reply to this Message

Neil - 20 Apr 2006 20:43 GMT

Mart,

Storing the picture themselves in your database is regarded as very bad
practice indeed as it can lead to massive database bloating. The accepted
method is to store a link to your picture file in a text field, although I
don't know how this will impact on your web based displaying of data.

The process of doing the linking is too complicated to explain here, but
check out the Access pages at www.nwarwick.co.uk for a full tutorial.

HTH

Neil
www.nwarwick.co.uk

> I have a database (Access 2000) of books and am wanting to include a picture
> of the books cover in one field. How would I do this ie. field type etc.
[quoted text clipped - 4 lines]
> TIA
> Mart

Reply to this Message