DBlank -
OMG. I figured it out and I'm none too happy but I'll get over it. My database is an Advantage database underlying a medical billing app that I'll call Alpha (because I certainly would not want to call out the @$!!%^$ software company by name).
Anyway, it just dawned on me (OK, I should have figured this out before) that we did an upgrade on the same day that was the endpoint for my data. A lot was going on that day so the correlation wasn't as obvious to me as it should have been.
In any event, the data tables were renamed and relocated in this upgrade. The old tables were in c:/alpha and the new tables are in c:/alpha/data. Now that I know this, I thought I could simply use the Datasource Location function to point CR in the right direction.
This is where I (still) need your help.
Using the either Database Expert or the Datasource Location function, I only see the standard database tree (Current Connections, Favorites, Hisotry, etc.) but I do not see how to repoint CR. CR sees the old c:/alpha location (which still has the legacy files in it) but apparently does not see c:/alpha/data. How do I force CR to look at C:/alpha/data?
Thanks.
Edited by bmurphywa - 13 Aug 2009 at 3:19am