SQL Server Compact 3.5 SP2 and 4.0 is supported on Windows 8 and 8.1, on desktop (not on Windows Store apps)
https://support.microsoft.com/en-us/kb/2681562
For SQL Server Compact editions
The following versions are supported in Windows 8.1, Windows 8, Windows Server 2012, and Windows 2012 environments:
- SQL Server Compact 3.5 Service Pack 2 and later versions
- SQL Server Compact 4.0 and later versions
Note No support is planned for Windows RT devices.
Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com