What am I doing wrong. I am "testing" ADO with a little Access 97 MDB.

I set ADO Data Control to a Query in the MDB (qryTest1). This is a basic
one-to-one relationship (there is a reason I've set up the files like
this... not important here.) I use a Left join.

I set up a button with   ADOctl.recordset.delete on the click event.

The form with the ADO control and bound text boxes can display the data fine
and will let me add records. But it won't DELETE a record. Says "Can't
delete from specifed files." and dies. It looks like the error is being
generated in Access97 and the OLE DB layer is passing it on or something.

The same app. with a DAO control instead works fine.

What is going on here?????? This is driving me nuts.

Thanks,

Paul

ANSWER: you need to use the CursorLocation property (on the ADO Data
Control)  = adUseServer

ADO is going to drive me crazy!!!

Paul

----------