>I have a large scale application used by over 350 clients. My company has decided to rename (and expand) this existing application (old name: EDWin new name: iePoint). I have successfully changed the project and related files to the new name. The existing DBC is named EDWin.dbc. I want to rename it to iePoint.dbc. I know that I can rename the DBC within the project, then issue VALIDATE DATABASE RECOVER to correct the backlinks for all tables. My question is this: how will I do this same process at over 350 clients? When the new application is installed at the client's site, the install process will run a VFP "fix" program, but I am not sure how to programatically rename EDWin.dbc to iePoint.dbc and fix the backlinks on all tables.
>
>BTW: I do use Stonefield - could this be of some help?
>
>TIA

Function RenDbc
lparameters OldName, NewName
Open data (oldName)
lnTables=adbobject(arrTables,'TABLE')
For ix=1 to lnTables
  lcTable = arrTables[ix]+'.DBF'
  handle=fopen(lcTable,12)
  =fseek(handle,8,0)
  lnLowByte = asc(fread(handle,1))
  lnHighByte = asc(fread(handle,1))*256
  lnBackLinkstart = lnHighByte + lnLowByte - 263
  =fseek(handle,lnBackLinkstart,0)
  Fwrite(handle,forceext(newName,'dbc')+replicate(chr(0),263),263)
  =fclose(handle)
Endfor
Close data all
Rename (forceext(oldName,'dbc')) to (forceext(newName,'dbc'))
Rename (forceext(oldName,'dcx')) to (forceext(newName,'dcx'))
Rename (forceext(oldName,'dct')) to (forceext(newName,'dct'))

Cetin