>>>>SQL Express 2008 R2 supports databases up to 10GB. That's bigger than moderate, IMO.
>>>>
>>>>>Is there some reason you are not considering SQL Server instead? There's a free version which will handle moderate sized apps. And if your target is corporate, you won't be laughed out of the room for suggesting a toy database like you will with FoxPro.
>>>
>>>Certainly a lot bigger than VFP.
>>>
>>>And secure, reliable, scalable, fast, easy to set up, and on and on...
>>
>>I'd not argue against SQL Express. But compared to VFP more:
>>
>>Secure ...... yes
>>Reliable.......yes
>>Scalable......yes
>>Fast............hmmmm..... yes with minor exceptions
>>Easy to set up.... nooooooo..... yes (once you've done it once)

I'm thinking of when you need to package up the installation of SQL Express as part of an automated install process and, by definition, not know what SQL servers are already on the target machine. The end user may or may not want to use an existing SQL server to host the database; if they opt for a new instance then the security settings need to be automatically set up to allow the application the neccessary rights, etc. . ..etc,....

If you are aware of anything that can automate this is an even semi-foolproof way please let me know.......