The biggest downside to using SQL Server Compact Edition is that it does not allow the creation of stored procedures. This seems to be Access with a different name...
I wrote a horseracing program on a 48K zx Spectrum from Sinclair, for the guys at the office who where playing the ponies, that predicted winners with a 60% accuracy...