Very frustrating error 3264

[Dave]

I have a subform, asubSampleXM, whose record source is a query from
two related tables. Whenever I delete a record I get an error 3264
"Operation not supported in transactions". If I open the subform on
its own (outside of the main form), I can delete records no problem at
all. I'm using Access 2000, with the latest update of Jet. I've tried
everything I can think of. Any ideas out there on what the problem
might be?

Thanks,

Dave B

 

[Dave]

I have a subform, asubSampleXM, whose record source is a query from
two related tables. Whenever I delete a record I get an error 3264
"Operation not supported in transactions". If I open the subform on
its own (outside of the main form), I can delete records no problem at
all. I'm using Access 2000, with the latest update of Jet. I've tried
everything I can think of. Any ideas out there on what the problem
might be?

Thanks,

Dave B

Something else I've just discovered...The poblem only occurs with the
stupid paperclip guy, the Office Helper. I can delete records from the
subform 'till the cows come home. And as soon as I show the
assistant...Error 3246 "Operation not supported......"

Annoying

 

[sluv]

I have a subform, asubSampleXM, whose record source is a query from
two related tables. Whenever I delete a record I get an error 3264
"Operation not supported in transactions". If I open the subform on
its own (outside of the main form), I can delete records no problem at
all. I'm using Access 2000, with the latest update of Jet. I've tried
everything I can think of. Any ideas out there on what the problem
might be?

Thanks,

Dave B

 

[sluv]

I have a subform, asubSampleXM, whose record source is a query from
two related tables. Whenever I delete a record I get an error 3264
"Operation not supported in transactions". If I open the subform on
its own (outside of the main form), I can delete records no problem at
all. I'm using Access 2000, with the latest update of Jet. I've tried
everything I can think of. Any ideas out there on what the problem
might be?

Thanks,

Dave B