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?

Kirtan Patel · Answer

Hi Partik Recommend you to use SQL Lite it Does not need any additional Installation of MDAC like Components or any SQL Server Installation its very compact and integrated and its very lite . and very Easy to use just same like SQL Server but its not the server database System.Data.SQLite Download its Connector for .net development http://sqlite.phxsoftware.com/ It Just Woks ;-) Happy Coding :)

patrick · Answer

A bit of testing and so far i have had no read or write errors from 2 computers (1 hosting the db and running the app 1 running the app and accessing the db file on a mapped drive) The forums on the sqlite page are great too. Thanks a lot for the advice this is making the project a lot more clean and reliable.

Kirtan Patel · Answer

Use Freeware Gui Tool Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibrisans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Times New Roman; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:Times New Roman; mso-bidi-theme-font:minor-bidi;} http://sourceforge.net/projects/sqlitebrowser/ its Nice to Manipulate it .

patrick · Answer

You havent steered me wrong yet and so far SQLite seems fit for what I need. Thanks again

Roei Bar · Answer

if you need a small db and its just for replacing Access i would recommend you to install SQLExpress its the ultimate response to change from access