Access or MSDE ?

[desmondtan]

I would to develop a database application used for single PC or single user only . The database only contains hundred of customer record , data entry form and reports .
Which data source should I use : MSDE or Acess ?

Please give commnets .

 

[Nerseus]

If youre not that familiar with SQL or databases, Id go with Access especially given that its only for a single user. If you may be moving to more users, Id look more into MSDE but if you plan on using dynamic SQL, either database should be easy to use.

-ner

 

[desmondtan]

Thank you the comments .
However ,
Most of the refrence book are talking about the MSDE and SQL . It is very difficult to troubleshoot a problem , get a reference and sample code when use Acess .

 

[Nerseus]

Well if all the examples you are finding and all of the books are all showing MSDE, then why not go that route?

Sometimes there is no perfectly "right" answer. If youre just starting out on something, your best bet is to learn the basics (how to make a connection, right SQL, retrieve and save data) and worry about the database part later.

Note that I wouldnt suggest this for a "real" project. But thats what prototypes are for - to figure out what works and what doesnt, especially when picking up something new (like .NET or Database access).

-Nerseus