Pedro Sorry, missed the bit about no gap so corruption is not the issue here. Don't think disk failure is too likely as the issue would be much greater - eg. no db at all. So. Are there other copies of the db that might have been written to? Is the db on FMServer? Stephen ---------- "How wonderful that we have met with a paradox. Now we have some hope of making progress." - Niels Bohr On Jul 26, 2010, at 9:22 AM, Pedro Perdomo-Miteff wrote: > Thanks Stephen for your prompt and kind response. > > I moved through the data as you suggested but can't find any trace of the > records. As I said before, there's not "gap" in record number. > > Do you think that a disk failure would the culprit? > > Best > > > > > -------------------------------------------- > Pedro Perdomo-Miteff, MD, MSc > Assistant Professor > Faculty of Medicine > Hospital Universitario de Caracas > Universidad Central de Venezuela > [log in to unmask] > [log in to unmask] > > > > > > On 26/07/10 10:02, "Stephen Wonfor" <[log in to unmask]> wrote: > >> Pedro >> >> The possibility exists that you may have corrupted indexes on those records. >> Typically they show up as "?" in all the fields. If you move through the data >> in order of record creation you may run across them - you can't (as far as I >> know) actually search for them using FMP finds but you can stumble across them >> by going through the data manually. >> >> If you do find them see http://fmdiff.com/fm/recordindex.html for help in >> sorting them out. >> >> Stephen >> >> ---- >> >> BELT SANDER: An electric sanding tool commonly used to convert minor >> touch-up jobs into major refinishing jobs. (---Attributed to the list at >> http://techtalk.parts-express.com/; Also claimed by others...) >> >> On Jul 26, 2010, at 8:18 AM, Pedro Perdomo-Miteff wrote: >> >>> Dear friends, >>> >>> Looking at my DB last night I realize, WITH ORROR that 3 records created >>> this month was missed. Is a not very complex DB running without trouble for >>> the last couple of years. >>> >>> Each record has creation date, incremental record number and client data. >>> >>> There is not a “gap” on creation dates. I can’t find the records searching >>> for date, record number or client name, as if the records were not ever >>> created. I’m sure that the records was created because I had printed a >>> recipe for each client. >>> >>> I’m working on FM 10.0v3, OS X 10.5.8. >>> >>> >>> I would appreciate your comments and help. Please excuse me for my bad >>> English. >>> >>> >>> >>> >>> >>> >>> >>> -------------------------------------------- >>> Pedro Perdomo-Miteff, MD, MSc >>> Assistant Professor >>> Faculty of Medicine >>> Hospital Universitario de Caracas >>> Universidad Central de Venezuela >>> [log in to unmask] >>> [log in to unmask] >>> >>> >>> >>>