Where do I begin? First, you're using string concatenation to build your SQL query. This is a HUGE security problem. Google for "SQL Injection Attack" to find out why. Next, Google for "VB.NET parameterized queries" to mitigate the problem. Oh, and a nice side effect of that is you get far better debuggable code out of it.
Next, you've got this:
SqlNonQuery = "insert into Log (StrInsert)"
Ummmm... you used string concatenation to build the SQL query and then you completely forget how to use string concatenation to finish building the query? I'd rather you didn't use concatentation at all and did the whole query thing properly instead of band-aiding this horrible code into working.
Oh, and SqlCe, at least version 5, is deprecated and no longer supported as of 4/12/16. You might want to move to a more current database engine, like SQL Express, LocalDb, SqlLite, or whatever.