Problem with "clean" database

[stevem2004]

I am getting the following error (ms access) when trying to input data:-

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

I know what the error means, there is no current record, my question is can I get the asp to ignore the fact that the database is empty and insert my new record?

TIA
Steve

[phpnovice]

Yes, just don't issue any move commands before doing an insert. However, you can also use error trapping, if needed, to get past the error.

On Error Resume Next 'turn on error trapping
...some statement...
If Err.Number <> 0 Then 'test for errors
...
End If
On Error Goto 0 'turn on default error handling

[Olórin]

I have never run across this when inserting informaiton into a "clean" DB. Generally only when I am trying to read or navigate through a recordset.

Could you post your code in and around where you are gettign the error?


- Olórin