"#Deleted" shows when input through MS Access to an Oracle 10g db
513756Mar 5 2008 — edited Mar 31 2008Hi, all
I am running an Oracle 10.1.0.2 database on a RH linux E3 server. I use a computer( Windows XP and Microsoft Office 2007)remotely to input data. I use the MS Access+ODBC oracle drives as the input tools.
Sometimes after I input a record, go to next record, and go back again, the fields show "#Deleted", so I can not edit them again! I have to reopen the MS Access to see the input data.
Has anyone here had such experience? What should I do to avoid this?
Any advice is highly appreciated!
Qian