Which would be better MS ACESS or SQL Server for VB Desktop application

5 Jul 2006 8:34 AM

Aditya

Hi , I am developing one desktop applicatons in which frontend is VB.net and database options I have are MS ACCESS and SQL SERVER as of now size of the databse is small but in future it can increase .can someone tell me pros and cons of both , can I use XML?

5 Jul 2006 9:51 AM

M. Posseth

well it all depends on your particular situation

there were several discussions in this group regrding this

see this one :
http://groups.google.nl/group/microsoft.public.dotnet.languages.vb/browse_thread/thread/c1596f56388fc0b0/771895983dfe3d68?rnum=7#771895983dfe3d68

wich might help you to choose the right one in your situation

regards

Michel Posseth [MCP]

Show quoteHide quote

"Aditya" wrote:

> Hi , I am developing one desktop applicatons in which frontend is VB.net and database options I have are MS ACCESS and SQL SERVER as of now size of the databse is small but in future it can increase .can someone tell me pros and cons of both , can I use XML?
>

5 Jul 2006 10:58 AM

Cor Ligthert [MVP]

Aditya,

This and all related newsgroups especially general and adonet are filled
with your question have a look at those. Here an English link to Google
according to that.

http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/search?group=microsoft.public.dotnet.framework.adonet&q=SqlServer+or+Jet+Access&qt_g=1&searchnow=Search+this+group

To make it short, 95 % points today to use SQLExpress instead, however there
are some situations were Jet (access) is a better choose.

I hope this helps,

Cor