>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.
Thanks for the reply, Hilmar, however I'm glad I can say it wasn't THAT bad of a day! I mean I am familiar with the USE command. <g>
The point of my posting was that when I try to open the table with no DBC open and I just USE the table using the path and file name, I get a dialog box saying it can't locate the DBC. When I open the DBC directly, then try to USE the table, giving it no file and path name, it tells me it can't find the file. When I USE it using the full path and file name, it tells me it can't find the file. (Yes, the file exists.) This is due to the forward link in the DBC to the DBF and the back link in the DBF to the DBC. The DBC wants to find the table in a certain place regardless of what I tell it and the DBF wants to find the DBC in a certain place even though the DBC is already open. But now the DBC and the DBFs exist in places different from where they reside on the server, so VFP is stumped.
I may have to resort to low level file functions to adjust the forward and back links before opening the tables.
