3.0.2

I did a collection renumber (by purchase date).  I noticed that an old box set was now at the top.  Sure enough, although the box set enrty had a purchase date, none of the individual titles in the box set had dates.  So, I entered the date (3/29/06) for the individual members and saved them.

Voila!  Now all 759 titles say "Error Loading Following Entry.  Delete This Record?"

It appears that my total database is unavailable.

What in the world happened, and is there a way to recover?

My online version is current.  I kept it current, figuring it could serve as a backup, if needed [but never thought it would be :-) ].  But now I wonder if I will lose the notes that I entered for some of the titles.

Thank you.

DG

Have you tried the repair database feature?

Don't take this personally, but I find it difficult to be sympathetic.  It's so very simple to backup one's database and I fail to understand why so many fail to do so.

I wonder if DVDP caches database changes in memory, or writes through to disk when edits are made.  I have not yet exited the program after renumbering and inserting dates.  If the database is memory resident while the program is running, and only writes to disk when the program exits, perhaps I could kill the process, and my changes (and presumably the problem) would disappear????


DG

If you still haven't closed the program you might indeed want to copy the folder of your database first. I'm not sure if it's the current version or the one before you started the program but it's definitely a backup in case the repair messes up things even more.

I tried to make a fresh backup, but, during the process, when it got to the profiles, it poped up an error message for each dvd.  DVDP does not provide a way to cancel the backup once it starts, nor does it provide a "No to all" response.  It also doesn't permit me to exit the program (once the backup starts).  So I was faced with either sitting there and manually replying "NO" 759 times (once for each profile), or using task manager to kill DVDP.

I killed it.

Then restarted it and everything was OK-- just the way it was before I attempted to enter the missing dates for the individual components of a box set, except that now there were "9/9/9999" dates, instead of blank dates in the "Purchase Date" fields.

So, I first made a new backup (worked fine), then edited the dates again.

This time, I discovered more about what really happened.  While entering one of the dates, I inadvertently entered the date in the "Purchased From", rather than the "Purchased On" field.  When you do that, the next thing that pops up is a prompt to ask if you want to edit the retailers list.  If you say "No", you immediately start getting error messages for every single profile.  If you say "Yes", and then cancel out because there really is nothing to edit in the retailer list (because the entry was an error), you still immediately start getting error messages for every profile.

In other words, a domain error in data entry broke the system.

The bad data entry was my fault ("pilot error").

Anyway, now my database is fixed, (and freshly backed up).

Regards,

DG