Access 97 backend Oracle - Write Conflict

  • Thread starter cmdex_VABCH via AccessMonster.com
  • Start date
C

cmdex_VABCH via AccessMonster.com

Would like some help.
I have an Access 97 front end with an Oracle back end. We recently updated a
table by adding fields. I refreshed the link to the front end. Now each time
a user attempts to change information on the table they receive a 'write
conflict' error message with two of three options available, 'copy to
clipboard', 'drop changes'. The 'save record' option is grayed out.
To make it more interesting, I have a copy of the database with the table
linked as usual, but I have not removed and relinked that table, so it does
not show the new fields. I can change the fields in this table. i.e. there
is no error message.
The changes to the table include adding 2 text, 14 number and 27 date fields.

The message occurs both while changing the record in the table view as well
as a form with the table as it's record source.

I have reviewed some previous posts here as well as on the microsoft support
web page. None seem to address the issue when both the table view and the
form recordset both have this issue.

I appreciate all your help.
Stumped.
 
C

cmdex_VABCH via AccessMonster.com

FYI:
It appears to be a DATE format issue. Oracle is extracting date information
from other sources (mainframe) and the century field is not maintained. I
was trying to use the MM/DD/YYYY format in Oracle to determine if the field
was indeed a date. I needed to use MM/DD/YY to correctly parse this date
field. Access 97 had difficulties dealing with the date field from Oracle
because is was substituting 00 for the century (0002 for 2002), where the
Access 2K version didn't have an issue. Go Figure!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top