Jpgs in a field

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding extra field to DB results at display time 3
creating a field displaying zero values 1
Displaying stored jpgs as pictures in a report 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Using selction criteria in report field 8
How can I add jpgs to Access record so they'll show up in reports 3
images on a form 3
Can I have a tickbox toggle a Byte Field from 1 to 0 ? 3

Top