FrontPage database update steps

[SteveBoard]

Using FrontPage 2002, I'm trying to modify database fields.

First, I attempted to use the "Database Interface Wizard." This failed. (The errors there were "supply defaults" etc. which I thought I did. Also the generated display exposes all the records, not a specific one, which means I can't risk having visitors update other people's records.)

Today I attempted to follow the steps offered by Microsoft in its white paper "How to Update and Delete Records in a Database Using Frontpage 2000."

I'm getting errors that say I must use an "updateable query." So it rejects my SQL Update statement.

I've used their sample query and one of my own typed into the database results custom query:

Here's one using literal field values:
UPDATE LOG.DBF SET ZIP = '17226' WHERE ZIP='"17225"'

Here's one using variables supplied by a form (the Microsoft example is generated by the wizard):

fp_sQry="UPDATE LOG.DBF SET ZIP = '::NewZip::' WHERE ZIP='""OldZip""'"

The extra double quotes comes from the database results wizard.

Suggestions?

 

[SteveBoard]

To answer my own inquiry, the problem here has been that the permissions were not set to anonymous or "everyone" and therefore the updates would not be accepted. "Not updateable query" is what the server tells you if you don't have permission to update a database.