Cindy:

Used OLE-DB and called Stored Procedures thru a COM object that returns a RecordSet. Perhaps I should've have stuck to a more conventional method ... grrr, then I could've have just switched like you suggested - a littel too late right now though.

Thanks anyway,

Mal

>Mal,
>
>How did you access the data? If you used views, you should be able to just change them all to local views. Try running GenDBC, editing the code to make local views, and re-running it to make your new database. As always, experiment on a copy!
>
>
>
>
>>Hi All:
>>
>>Almost finished with an application using VFP and SQL SERVER 7.0.
>>
>>Now that I look at the whole application, I may have jumped in to SQL SERVER without really considering it's necessity. I think the whole application may do just fine using VFP's database. Of course, never say never, but, I think that none of the tables will hit the 2GIG limit.
>>
>>Question? ... DO I REDO THE DATABASE PORTION OF THIS APPLICATION?
>>If I can rewrite the application to use DBC's, it will save some upfront cash - the amount needed to purchase a 25 USER SQL SERVER 7.0.
>>
>>What would you do?
>>
>>TIA