Jim ---
There is no pat answer. The MSDE engine has a 2GB engine but it is totally compatible with SQL Server and can scale up real easily.
>Hey JohnK!
>
>I just might have to do that *if* you can advise whether ACCESS in that flavour will still have a 2-gig TOTAL database size limit or NOT.
>
>Cheers,
>
>Jim N
>
>>Hi JimN
>>
>>>
>>>While I agree with your writing, my concern remains that a focus on mid-tier means that we can expect little or nothing new or improved on the UI and UI-related functionality.
>>>
>>
>>That is a concern. Someone brought up the new MSDE data engine yesterday and asked whether VFP would support this. When you think about it, it would be nice if you could link in native support for MSDE (sorta like the replaceable database drivers in old Clipper).
>>
>>>This is why I have started to learn VB and why I have my ears open for a VFP-like product with a SMALL BUSINESS future.
>>>
>>
>>Jim, if you really want a small business product, get your hands on an Office2000 beta and look at Access2000.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05