Accepted 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 :)

patrick17y ago

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 Patel17y ago

Use Freeware Gui Tool

http://sourceforge.net/projects/sqlitebrowser/

its Nice to Manipulate it .

patrick17y ago

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

Roei Bar17y ago

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

Wasted a day on sql compact edition

5 Replies

System.Data.SQLite