Is SQL CE the best choice?

  • Thread starter Thread starter cgr
  • Start date Start date
C

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?
 
cgr said:
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?
Click to expand...

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/
 
Back
Top