MS ACCESS ODBC PROBLEM HELP!

I am using Oracle 8 Server, and MS Access 97 as a front end. Lets take an example that looks like this

Table: XXX
Fname varchar2(20)
lname varchar2(20)
*** No Keys

in access if I am in table view and insert a record lets say the data looks like this:
(Andrew, Abrams) I can insert the record and in turn move off the record,
move back on to the record and modify either field.

The problem is when I leave a field blank, consider the following data:
(Andrew,) [A first name with no last name]. I can enter the data, move off
the record, and when coming back to update I get an error to the effect that another user is currently modifying the record. I can use SQL worksheet and update that way, but not from Access. What gives? Received on Tue Sep 22 1998 - 00:00:00 CDT