If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > FileMaker > Phantom records!??

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-15-07, 01:00
Rod Randall Rod Randall is offline
Registered User
 
Join Date: Jun 2005
Location: Perth, Western Australia
Posts: 7
Unhappy Phantom records!??

I've had this problem before, several years ago and I had to create a new
table and reload my data to get rid of the problem then.
What is happening is very weird. I have 152 records in a table that have
somehow got another empty (phantom) record, in the same table, associated with them.

To find them I do a search for duplicate records using the "!" character
and I get 304 records returned but 152 are empty records. I can't add any
text into any fields in these records and can't delete them without crashing
Filemaker. However if I delete the associated records, the ones which do
have text in the mandatory fields these records dissappear.
However when I reload the 152 records these phantom records reappear.

If I try a global change on these 304 records the change only effects the
legit 152 and a message says the other 152 are either in use or I don't
have permission to alter them, neither is true of course.

Has anyone else experienced this problem? I don't want to have to reload a
new table, it'll take way too much time. Why would thes 152 records create
these ghost records? Last time it was only two records that did this and it
took ages to get rid of the problem by reloading the entire database. That
was years ago now and the database is exponentially bigger...

Help!
Reply With Quote
  #2 (permalink)  
Old 03-28-07, 22:53
<Ender> <Ender> is offline
Registered User
 
Join Date: Aug 2005
Location: Minneapolis, MN
Posts: 56
Hmm, phantom records that can't be deleted is a sure sign of corruption. You should recover what data you can from the file and revert to a recent backup that doesn't have the problem.

There's usually some circumstance that starts corruption, like sharing a file through the OS, or if a file is not closed properly. You should ensure that you're doing what you can to reduce these circumstances and also that you mitigate the damage by having regular backups.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On