Error 3086

[Frankie via AccessMonster.com]

Hi there,

I am getting really frustrated with this one.

So far I was able to run a delete query without problem which now gives me
the error 3086 message without any obvious reason.

This query, linked to sub calculation queries, is meant to delete all
records on a table, then followed by an append query with new records. This
table is linked from Excel to feed a Pivot Table.

This is not a security issue.
I have also tried the "DISTINCTROW" thing I read from other posts to no
avail.
Here is the SQL :
DELETE RqtePointCAGraph.DateFacture, RqtePointCAGraph.SommeDeFacTTC,
RqtePointCAGraph.SommeDeMtFactHT, RqtePointCAGraph.SommeDeSommeDettlHTR,
RqtePointCAGraph.[SommeDeSommeDeMtTTC-R], RqtePointCAGraph.
[SommeDeSommeDeMtTTC-D], RqtePointCAGraph.AchatsRelHT,
RqtePointCAGraph.MargeFactHT, RqtePointCAGraph.TresorerieTTC
FROM RqtePointCAGraph;

Some help would be greatly appreciated.
Thanks in advance
Frankie

 

[Michel Walsh]

Hi,


DELETE tableName.* FROM tableName


you delete (remove) the whole row, not just some of its columns, so, supply
a *, not a list of columns.

To "erase" the value under some columns, while keeping the record, use an
UPDATE and SET those columns to NULL (or to a default value).



Hoping it may help,
Vanderghast, Access MVP