I am trying to do the same in the Buisness Object. How do I get a Blank Date into a date field and gen into a General Field. Currently, If I allow nulls, it seems to put a date of 01/01/1800 intot he date field.
Also, when I drop the Field onto the form, there is no automatic formatting based on the field size in the table (e.g. say Numeric field with 10 digits and 4 decimals is displayed as just decimals). Is there any automatic way to take the formatting from the table i.e. in example it would have a mask of 999999999.9999
Just to echo Trent and Paul's comments, I'd definately look into SQL Express as an alternative to MySQL if possible. MySQL is a fine database, but in my experience, SQL Express provides a great (also free) alternative that will give you much more room for growth and a tighter integration with .NET. I haven't had much experience with MySQL recently, so many of my old gripes may have bene resolved, but SQL Express will certainly give you a better "ceiling" by way of the enterprise edition both on scaling and on the coding end as well (i.e. T-SQL support.)
Obviously, the main caveat to going with SQL Express is if the memory or cpu limitations Trent mentioned are going to really hamper you (i.e. you are planning on using it in a demanding or high-volume environment.) For 15 users, however, I highly doubt you'll notice the limitations at all.
The file size issue isn't as big of a deal unless you are planning on storing media files within the database. As Paul mentioned, you can always split your database into multiple file groups to handle a larger number of records (which, excluding media files, would need to be pretty large to begin with to exceed 4 GB.)