Gary DeWitt gave a presentation at Great Lakes Great Database Workshop where he indicated that you could have 15 people access the database, but when the 16th person accessed it, performance took a hit. How many users do you have?

>Okay ... the first thing I saw was a 5 USER limit. That rules out MSDE. SBS may the better ... looking into that now.
>
>Thanks anyways Chris.
>
>>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.