I am running into a problem and curious if anyone has seen it. Received a Base database via email.
The database file was created using OOo2.2 under MS Vista. In one particular table there are, what appear to be deleted records that do not show in a dataview window. They are not returned if one just queries the single table. But if one uses that table in a join, then they records are returned. In other words - I have deleted all the records from the table. Open it in a data view and it has no records. Run a query such as SELECT * FROM "CheckOut" and receive no records back. Run this instead SELECT COUNT( "PatronID" ) FROM "CheckOut" and I get a value of 109. Run this SELECT *, * FROM "Patron", "CheckOut" WHERE "Patron"."PatronID" = "CheckOut"."PatronID" I get 109 records, with all the data for the deleted records in CheckOut. I have run an explicit CHECKPOINT, and SAVE COMPACT No change. The results are the same for all the actions above when I have used OOo2.3M_1 and StarOffice 8 Update 7 Has anyone else had this problem? For now I am going to migrate their data to a new database, to insure consistency. Then email it back to them. I have asked them to work with it for a few days under VISTA and then email it back to me, so that I can see if the deleted records are 'stikcing' again. Thanks
