Is SQL CE the best choice?

[cgr]

I'm considering using SQL CE, Access or even SQL Express to convert an Excel
solution to a VB.NET solution.

The results of this internal application are used to develop the wiring
specifications.

The database will be pretty small. There will be about ten tables. The
average table will have less than fifty rows and and five columns. The main
table will have less the five thousand rows and twenty columns.

Typically only two users will manipulate data via .NET application(s).

Is SQL CE the best choice?

 

[Tony Toews [MVP]]

I'm considering using SQL CE, Access or even SQL Express to convert an Excel
solution to a VB.NET solution.

The results of this internal application are used to develop the wiring
specifications.

The database will be pretty small. There will be about ten tables. The
average table will have less than fifty rows and and five columns. The main
table will have less the five thousand rows and twenty columns.

Typically only two users will manipulate data via .NET application(s).

Is SQL CE the best choice?

1) Will SQL CE allow multiple users?

2) Even if it did I'd likely use Access for the sheer convenience of
being able to look at the data very conveniently while developing and
debugging the app.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/