You'll probably want to post your code. It has been my experience that the error messages you receive don't necessarily match the situation. I got a similar error the other day when I tried to Close a recordset. The reason I got the error was I had forgotten to Update the recordset after adding a new record.
If you post your code, let us know where the error is occuring.