DB update - delete error (SP3 problem?)

M

Mettá

Following numerous ongoing problems, (possibly caused after installing MS
SP3) with custom DRWs I now have another problem with a simple DRW access db
record update or delete.

Is "DISTINCT" no longer available or something???

DELETE DISTINCT from TableName WHERE Id=::Id:: and FirstName='::FirstName::'




Page 1 posts the Unique ID and First Name as a kind of safety net. The
following error results...

Database Results Error
The operation failed. If this continues, please contact your server
administrator

Any ideas folks....

M
 
T

Thomas A. Rowe

To use Distinct your would have to supply a field name, as in Distinct(fieldname), however for
deleting a record, as long as table had a ID (autonumber) field, then you can just use that.

Delete * from table where ID = " & ID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
M

Mettá

Hi Thomas

I have revised the delete query as

DELETE * from TableName WHERE Id=::Id:: and FirstName='::FirstName::'

I am still getting the same error??

Thanks
M


Thomas A. Rowe said:
To use Distinct your would have to supply a field name, as in
Distinct(fieldname), however for
 
T

Thomas A. Rowe

What happen when you just use:

"DELETE * from TableName WHERE Id= " ::Id::
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 

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