Wasted a day on sql compact edition

Question

I spent a few hours changing from access database to sql compact, only to find out compact wont run off a shared drive... I am running low on time and am no closer to my solution. Would SQLLite be more appropriate?