Appending a database -- Says EOF reached, and cant add

[kfcSmitty]

Using Access 2002 - VBA

How could I add a new record in the table in my database? I want to input information from a form, but it doesnt have enough rows to handle the information.


It keeps saying file is at EOF or BOF.

[kfcSmitty]

*edit*

just look at above post, all over problems have been fixed

[brucevde]

Why even issue a MoveFirst? When a recordset is opened, it is always at the first record unless there are no records (obviously). But if you insist, just make sure there are records in the recordset.

RsStorage.Open "Splits", cn, adOpenKeyset, adLockPessimistic, adCmdTable
    If Not (rsStorage.BOF And rsStorage.EOF) Then 'ie the table is empty
       RsStorage.MoveFirst
    End If

[kfcSmitty]

*edit* just look at the first post -- everything else has been solved

[si_the_geek]

EOF or BOF is not an issue that should matter if you are adding a record.

Post your code so we can see the problem.