Hi Cetin
The Database WORLD.DBC and its tables are all in the DATA folder.
The pathing given by me in the APP is

SET PATH TO temp;progs;DATA;reports;FORMS;MENU;libs;CURSORS;pics;DLL

over the network this path fails. (look at the err msg below it references the client machines C Drive for the data)

all this works fine on the APPLICATION SERVER but it gives the error when u try to run the app from the client machine. Last night i have reformatted my hdd and re-installed windows and VFP7 without the sp1 patch, i havent tried running the app on the new installation but will let you know when i have done.





>>Hi
>>
>> I have a stange problem and i figure this could be a BUG (not sure).
>>
>>Earlier I had put the problem on UT but i didnt get satisfactory reply and I havent seen this problem being posted on UT.
>>
>>Following is my machine configuration -
>> W2K Adv Server with SP4 installed.
>> VFP 7.0 With VFP70SP1.MSP + VFPODBC.MSI
>> CR 8.5 with SP1
>>
>>
>>Following is my network application setup -
>> Machine A (NETBIOS name of the machine is SRV) - Main application Server . The application database (WORLD.DBC) with the tables is installed in the share WORLDAPP
>>
>> CLIENT MACHINES - are configured to start the application locally on their machine but the database is accessed across the network via the following path \\SRV\WORLDAPP
>>
>>The problem i face now is that when the application is started from a client machine the following error is popped to the user (this never happened to me before applying the VFPSP1)
>>
>>*------------------------------------------------------------------------------------------
>>c:\WORLDAPP\Data\WORLD.DBC : Cannot Link tabe '\\... \database\user.dbf' to this database:
>>duplicate or missing fields. Would you like to try to locate the owning database or
>>delete the link (and free the table)?
>>
>> LOCATE DELETE CANCEL
>>*-------------------------------------------------------------------------------------------
>>
>>
>>If i configure my client machines to work in the following manner than the app works fine and there is no error reported.
>>
>> CLIENT MACHINES - are configured to start the application on the server
>> TARGET : \\SRV\WORLDAPP\WORLD.EXE
>> START IN : \\SRV\WORLDAPP
>>
>>
>>Another interesting thing is this only happens with the DATABASES i have created on this configuration (VFP7.0+SP1+VFPODBC.MSI). My earlier applications works fine and doesnt show any backlink error (possibly bcoz i had not applied vfp70sp1.msp patch).
>>
>>Does anybody have a similar problem !
>
>Sanjay,
>I've been working with VFP7+SP1 almost since its release. I've never seen such a problem.
>I suspect it's your pathing.
>In your message :
>
>"c:\WORLDAPP\Data\WORLD.DBC" shows as database but .dbf is from another path. Probably during development you had the data in 'data' folder and form DE's now find a world.dbc from a 'data' subfolder. Try renaming the data folder to something else (ie:datax).
>Cetin