Problem with UPDATE on Custom Query

S

Stephen

Hi

I'm using FrontPage 2000 and Access 2000

I need to update an Access text field while online.

When the record is originally created it is set to default and include an image
file.

<img src=images/image1.jpg>

When a new member joins and submits a new image via email
I need to OVERWRITE the original <img src=images/image1.jpg> with

<img src=images/MEMBERS_IMAGE.jpg>

In the database I have got a 2 fields: old_image AND new_image

In FP I have tried the Custom Query

UPDATE epropertytable SET new_image='::new_image::' WHERE
old_image='::eek:ld_image::'

But the table is not updating.

Any thoughts - thanks in advance - Stephen
 

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

Top