Hi Chris:

Good suggestion!

I'll check out the Wikis.

I use OLE-DB ADO Command Objects and strictlty Stored Procedures for data read/writes ... never mind, I'll check out MSDE first and post questions should I have any.

Thanks,


>>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?
>
>You may want to use MSDE. MSDE stands for Microsoft Data Engine. It is basically SQL Server 7.0, with some limitations (database size, number of users) and it's freely distributable!. You can check out some articles at the Fox Wiki:
>
>http://fox.wikis.com/
>
>or at the Microsoft site:
>
>http://msdn.microsoft.com/vstudio/msde/
>
>This is a nice solution because if your database does grow, or you have too many users, you can switch easily to SQL Server.