>I have a situation where the pathing of the production copy of some data is different than it is on my local machine. I normally don't have to deal with this since my apps run from any folder a user wants to place it, but the DATA folder is usually a subfolder and all the tables and the DBC reside there (they can change this, but no one ever does). In this situation, the tables are on one drive and the DBC is on another (they are on the same physical server, perhaps even the same physical drive, but the data is on mapped drive J: and the DBC is on mapped drive W:). So when I copy this DBC and the tables over to my computer and try to open a table, it tells me it can't find the database and shows the path as J:yada,yada,yada (you never knew Jerry Seinfeld was one of the VFP developers, did you?).
>
>How do I get this table open? I'm probably forgetting something obvious - it's been that kind of day - but I was thinking it wouldn't look for the exact path if the DBC was open and your referenced it, as in DBCName!TableName. No dice. Or if the DBC was set as the current DBC. No dice there, either. What gives?
>
>Russell Campbell
I think there would be two ways to open the tables under these circumstances:
1. Open the database first.
open database (lcDatabaseDir + MyDatabase)
use MyTable1
2. Open the table directly.
use (lcTableDir + MyTable1)
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)