Jpgs in a field

M

Mart

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
 
N

NetworkTrade

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

Neil

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
 
Top