Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> #Deleted message showing in all fields on an access form
Hello all
I am cuurently in the process of upsizing a database from Access to Access as a front end and Sybase SQL Anywhere 5.0 as the datasource. This is the first time that I've done any work in Sybase before and I have come up against some problems.
The main problem I'm encountering is that when I open one of my forms for data entry (main form subform opened in data entry mode due to the large number of records) all the fields have #DELETED in them. If I try to do anyting within the deleted fields I get a message saying that the record was deleted by another user (I am the only one currently using the database). I therefore cannot do anything with the record which shows #DELETED, however I can add new records.
I've looked at the manual till I'm blue in the face but cannot find any solution. If anyone has come across this problem before I would appreciate any help that they can offer.