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 Sun Sep 27 1998 - 20:38:48 CDT
