I want to create a SQL Compact Database to use with my app but when trying to do it with the IDE (2005) I get all sorts of strange messages (like this cannot be the final method (of creation) etc) and it will not let me do it.

I have searched this forum and all of the examples appear to be in the 2003 version of dot net and when I have tried to copy the code it does not work with my 2005 IDE, I even tried to rename the Northwind database example that comes with the Compact Database files and then connect to that but you guessed it that did not work either

There surely must be a simple way to do this ? Can somebody please point me in that direction?