For MSA 97 it should be "*" after "DELETE"
"DELETE * FROM snippets WHERE snippet_id = 34"
----- Original Message -----
From: "Shane Witbeck" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 04, 2000 9:27 AM
Subject: Access 2000 db problem
> Im using access to store info on code snippets and I keep getting this
same
> error. The only way I have found to "fix" the problem is to re-build the
> access table. I experience the following error when I try to update or
> delete a record in the table (with CF OR editing the table directly in
> Access):
>
> ODBC Error Code = S1000 (General error)
>
>
> [Microsoft][ODBC Microsoft Access Driver] The search key was not found in
> any record.
>
>
> SQL = "DELETE FROM snippets WHERE snippet_id = 34"
>
> Data Source = "DSMAIN"
>
> Any suggestions would be appreciated.
>
> Sincerely,
> Shane Witbeck
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
