Hi Peter (and Jeff):
I did not delete the CPD file because it's been my understanding that RH now automatically deletes and recreates it upon each launch!!!! I tried that though and it certainly did do the trick. Unbelievable. I really thought the cpd was clobbered on each open.
Thanks for posting this Jeff. I just opened it in MS Access to take a gander. So incredibly cool to see all the tables. Will for certain be helpful to know this.
You CAN set this to happen each time you open up the project (I do), but large projects can get bogged down when rebuilding the CPD each time. If you don’t mind the wait, you can set it to blitz & rebuild the CPD each time. I think it’s in your Prefs, but it’s been so long since I turned it on, I forget.
The CPD used to be very Access version specific. It was OK to open it in a
later version as long as no changes were made. Back then I would have
recommended opening a copy of the CPD rather than the original.
Now it's perfectly normal to delete the CPD and let Rh rebuild it as that
step is now more robust. Just mentioning this in case you do edit the CPD
and then have other issues. The CPD is built from other files but if you
make changes, those files do not get updated. It's a one way street.
It is deleted each time you open Rh if you select that check box in Tools >
What would I do without you guys.
Thanks...I'd rather set it to recreate each time as the mysterious behavior is very random and we may not catch something more serious.
You guys are awesome. Thank you so much!
I'm not clear whether you mean you do or don't want the CPD to be deleted
and recreated each time. Also I'm not clear how that tells you anything.
I do want it to be deleted each time. I really thought it was automatically as I don't recall the tools option being necessary before. Setting it doesn't tell me anything. Setting it and deleting the cpd file fixed the scrambled brains of our image table in the database. I purged the CPD and all is now well. If we set it to delete each time, given that we mess around with so many images, presumably RH can keep itself from getting scrambled again.