I tested my code with CR9 Developer.
>Craig,
>
>Thanks for the reponse. Not sure if I mentioned it, but I am
>using Crystal 9, Dev Edition. Not sure if it matters either.
>
>I Just ran the code you posted. I get the error:
>"OLE Dispath.. ActiveX Designer...The table 'Client' could not be found"
>
>I have zipped my sample stuff into a small zip file
here!>
>The prg is called SetLoc.prg. The contents of Temp1 are the
>original tables. Temp2 has the same tables renamed. I want to be able to
>point to either set in runtime.
>
>Would you try it please? Many Thanks
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer