473,900 Members | 3,343 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Why choose SQL Express over Access?

ljh
Why would you choose SQL Express (which requires an installed application to
work) over the simplicity of an Access database which has no dependencies?

May 30 '06
74 3819
Frank,
Can you point to something that documents your assertion that SQL Express
does not run on XP Home? Runs fine on my XP Home test machine....Have n't
been able to test access across a network to SQL/e on XP Home.
"Frank Rizzo" <no**@none.co m> wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..
Sahil Malik [MVP C#] wrote:
The only advantage Access gives you is "File based deployment". And
frankly SQL Anywhere (or was it everywhere - I loose track in all these
name changes) should be a better choice for desktop-ish applications
anyway.


There is one more Access advantage: it'll run on Windows XP Home Edition,
while SQL Express will not (requires XP Pro). So if you are targeting
mom&pop shops or the home market, either do Access or stick to MSDE.

Regards

May 31 '06 #41
Well, both INETA speakers and MVPs are unbiased.

I'm an INETA speaker and MVP myself, and nearly don't have the same pedigree
as Bill Vaughn, but I must agree with his views on Microsoft.

- Sahil Malik
http://www.winsmarts.com
http://blah.winsmarts.com

"ljh" <So**@where.els e> wrote in message
news:ai******** ********@bignew s5.bellsouth.ne t...
"INETA Speaker" - at least you're unbiased.
"William (Bill) Vaughn" <bi************ **@nwlink.com> wrote in message
news:Om******** ******@TK2MSFTN GP04.phx.gbl...
Ah SQL Express can be used with an IIS web site. SQL Everywhere cannot.
It's not designed to do so but SQL Express (still free) is.
Microsoft has done more for small business than any company I know. It
now offers three versions of its database technology for free. SQL
Everywhere, SQL Express and SQL Express Advanced Services that includes
the Reporting Services engine as well as Full Text Search.

If you just want to bash Microsoft, find some other forum.

--
_______________ _______________ ______
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
_______________ _______________ ____

"ljh" <So**@where.els e> wrote in message
news:_J******** ***********@big news3.bellsouth .net...
Awesome!

It doesn't look like they'll let us use it to power webservices under
IIS though.

That would suck. Allowing its use under IIS would make hosted web
development so much easier!

It would let small companies with big ideas give those ideas a shot at
succeeding without spending several thousand dollars for SQL Server.

But, I don't think MS is all that interested in helping small businesses
grow. And, that's too bad. Doing so would actually fatten the bottom
line at MS as the little businesses need more MS licenses and maybe a
"grown up" version of SQL Server.

If they did, who knows, it might even unseat MySQL as the web db king.

Thanks for the great link!

"William Stacey [MVP]" <wi************ @gmail.com> wrote in message
news:Od******** ********@TK2MSF TNGP03.phx.gbl. ..
Another option for you may be SQL Everywhere. I think will be released
this
summer. 1.4mb with 7 dlls.
http://blogs.msdn.com/stevelasker/ar...whereInfo.aspx

--
William Stacey [MVP]

"ljh" <So**@where.els e> wrote in message
news:Dm******** ***********@big news3.bellsouth .net...
|I mean that you can use Access databases simply by including the .mdb
files
| with your application, whereas using SQL Server Express requires that
you
| install SQL Server Express and have it running in the backgound.
|
| In the event that I use SQL Server Express and need to redistribute
it
with
| my app, is there a silent install available?
|
| <ja**********@g mail.com> wrote in message
| news:11******** **************@ u72g2000cwu.goo glegroups.com.. .
| > Well, I'm not sure what you mean by "requires an installed
application
| > to work". I just downloaded it, ran the setup & it worked. And,
since
| > your reluctance to do that is the *ONLY* requirement you specify
for
| > your database needs, it's really hard to answer your question.
| >
| > So, the advantages of SQLExpress over Access, as I see them.
| > 1) It's free.
| > 2) It's directly compatible with Sql Server.
| >
|
|



Jun 1 '06 #42
ljh
Of course you must....

"Sahil Malik [MVP C#]" <co************ *****@nospam.co m> wrote in message
news:u3******** ******@TK2MSFTN GP05.phx.gbl...
Well, both INETA speakers and MVPs are unbiased.

I'm an INETA speaker and MVP myself, and nearly don't have the same
pedigree as Bill Vaughn, but I must agree with his views on Microsoft.

- Sahil Malik
http://www.winsmarts.com
http://blah.winsmarts.com

"ljh" <So**@where.els e> wrote in message
news:ai******** ********@bignew s5.bellsouth.ne t...
"INETA Speaker" - at least you're unbiased.
"William (Bill) Vaughn" <bi************ **@nwlink.com> wrote in message
news:Om******** ******@TK2MSFTN GP04.phx.gbl...
Ah SQL Express can be used with an IIS web site. SQL Everywhere cannot.
It's not designed to do so but SQL Express (still free) is.
Microsoft has done more for small business than any company I know. It
now offers three versions of its database technology for free. SQL
Everywhere, SQL Express and SQL Express Advanced Services that includes
the Reporting Services engine as well as Full Text Search.

If you just want to bash Microsoft, find some other forum.

--
_______________ _______________ ______
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
_______________ _______________ ____

"ljh" <So**@where.els e> wrote in message
news:_J******** ***********@big news3.bellsouth .net...
Awesome!

It doesn't look like they'll let us use it to power webservices under
IIS though.

That would suck. Allowing its use under IIS would make hosted web
development so much easier!

It would let small companies with big ideas give those ideas a shot at
succeeding without spending several thousand dollars for SQL Server.

But, I don't think MS is all that interested in helping small
businesses grow. And, that's too bad. Doing so would actually fatten
the bottom line at MS as the little businesses need more MS licenses
and maybe a "grown up" version of SQL Server.

If they did, who knows, it might even unseat MySQL as the web db king.

Thanks for the great link!

"William Stacey [MVP]" <wi************ @gmail.com> wrote in message
news:Od******** ********@TK2MSF TNGP03.phx.gbl. ..
> Another option for you may be SQL Everywhere. I think will be
> released this
> summer. 1.4mb with 7 dlls.
> http://blogs.msdn.com/stevelasker/ar...whereInfo.aspx
>
> --
> William Stacey [MVP]
>
> "ljh" <So**@where.els e> wrote in message
> news:Dm******** ***********@big news3.bellsouth .net...
> |I mean that you can use Access databases simply by including the .mdb
> files
> | with your application, whereas using SQL Server Express requires
> that you
> | install SQL Server Express and have it running in the backgound.
> |
> | In the event that I use SQL Server Express and need to redistribute
> it
> with
> | my app, is there a silent install available?
> |
> | <ja**********@g mail.com> wrote in message
> | news:11******** **************@ u72g2000cwu.goo glegroups.com.. .
> | > Well, I'm not sure what you mean by "requires an installed
> application
> | > to work". I just downloaded it, ran the setup & it worked. And,
> since
> | > your reluctance to do that is the *ONLY* requirement you specify
> for
> | > your database needs, it's really hard to answer your question.
> | >
> | > So, the advantages of SQLExpress over Access, as I see them.
> | > 1) It's free.
> | > 2) It's directly compatible with Sql Server.
> | >
> |
> |
>
>



Jun 1 '06 #43
SQL Express will run on XP Media center.
--

- Sahil Malik
http://www.winsmarts.com
http://blah.winsmarts.com

"_DD" <_@nospam.com > wrote in message
news:oc******** *************** *********@4ax.c om...
On Tue, 30 May 2006 15:49:50 -0700, Frank Rizzo <no**@none.co m> wrote:
Sahil Malik [MVP C#] wrote:
The only advantage Access gives you is "File based deployment". And
frankly
SQL Anywhere (or was it everywhere - I loose track in all these name
changes) should be a better choice for desktop-ish applications anyway.


There is one more Access advantage: it'll run on Windows XP Home
Edition, while SQL Express will not (requires XP Pro). So if you are
targeting mom&pop shops or the home market, either do Access or stick to
MSDE.


There are lots of places where an app that normally runs on high-end
XP Pro machines would have to run on XP Home as well. Does this mean
that applications must fit the common denominator: MSDE? I didn't
think MSDE was still supported.

And what about XP Media Center? I'd love to find out about future
plans to adapt to MC and Home editions, assuming there is no way to
target them now.

Jun 1 '06 #44
Excuse me? Are you accusing us of something? I would make pretty sure you're
on solid ground before impugning our honesty in a public forum. If you
really knew me, if you really understood where I have stood for the last 20
years, you would not be saying anything about how I coddle Microsoft or show
bias toward their products. From time to time I have been highly critical of
Microsoft--even as an employee (for 14 years). Microsoft has not always
liked to hear what I have said, but they have listened--just as they listen
to every one with any credibility at all. I for one have just finished my
11th book on this subject and yes, this book like all the others talks about
what works and what does not.

Do you think you fall into that category?

--
_______________ _______________ ______
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
_______________ _______________ ____

"ljh" <So**@where.els e> wrote in message
news:3C******** *********@bigne ws1.bellsouth.n et...
Of course you must....

"Sahil Malik [MVP C#]" <co************ *****@nospam.co m> wrote in message
news:u3******** ******@TK2MSFTN GP05.phx.gbl...
Well, both INETA speakers and MVPs are unbiased.

I'm an INETA speaker and MVP myself, and nearly don't have the same
pedigree as Bill Vaughn, but I must agree with his views on Microsoft.

- Sahil Malik
http://www.winsmarts.com
http://blah.winsmarts.com

"ljh" <So**@where.els e> wrote in message
news:ai******** ********@bignew s5.bellsouth.ne t...
"INETA Speaker" - at least you're unbiased.
"William (Bill) Vaughn" <bi************ **@nwlink.com> wrote in message
news:Om******** ******@TK2MSFTN GP04.phx.gbl...
Ah SQL Express can be used with an IIS web site. SQL Everywhere cannot.
It's not designed to do so but SQL Express (still free) is.
Microsoft has done more for small business than any company I know. It
now offers three versions of its database technology for free. SQL
Everywhere, SQL Express and SQL Express Advanced Services that includes
the Reporting Services engine as well as Full Text Search.

If you just want to bash Microsoft, find some other forum.

--
_______________ _______________ ______
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
_______________ _______________ ____

"ljh" <So**@where.els e> wrote in message
news:_J******** ***********@big news3.bellsouth .net...
> Awesome!
>
> It doesn't look like they'll let us use it to power webservices under
> IIS though.
>
> That would suck. Allowing its use under IIS would make hosted web
> development so much easier!
>
> It would let small companies with big ideas give those ideas a shot at
> succeeding without spending several thousand dollars for SQL Server.
>
> But, I don't think MS is all that interested in helping small
> businesses grow. And, that's too bad. Doing so would actually fatten
> the bottom line at MS as the little businesses need more MS licenses
> and maybe a "grown up" version of SQL Server.
>
> If they did, who knows, it might even unseat MySQL as the web db king.
>
> Thanks for the great link!
>
>
>
> "William Stacey [MVP]" <wi************ @gmail.com> wrote in message
> news:Od******** ********@TK2MSF TNGP03.phx.gbl. ..
>> Another option for you may be SQL Everywhere. I think will be
>> released this
>> summer. 1.4mb with 7 dlls.
>> http://blogs.msdn.com/stevelasker/ar...whereInfo.aspx
>>
>> --
>> William Stacey [MVP]
>>
>> "ljh" <So**@where.els e> wrote in message
>> news:Dm******** ***********@big news3.bellsouth .net...
>> |I mean that you can use Access databases simply by including the
>> .mdb files
>> | with your application, whereas using SQL Server Express requires
>> that you
>> | install SQL Server Express and have it running in the backgound.
>> |
>> | In the event that I use SQL Server Express and need to redistribute
>> it
>> with
>> | my app, is there a silent install available?
>> |
>> | <ja**********@g mail.com> wrote in message
>> | news:11******** **************@ u72g2000cwu.goo glegroups.com.. .
>> | > Well, I'm not sure what you mean by "requires an installed
>> application
>> | > to work". I just downloaded it, ran the setup & it worked. And,
>> since
>> | > your reluctance to do that is the *ONLY* requirement you specify
>> for
>> | > your database needs, it's really hard to answer your question.
>> | >
>> | > So, the advantages of SQLExpress over Access, as I see them.
>> | > 1) It's free.
>> | > 2) It's directly compatible with Sql Server.
>> | >
>> |
>> |
>>
>>
>
>



Jun 1 '06 #45
Bill, it took me a while to realize this, but I think you're wrestling with
a pig. He is enjoying it, and you're getting dirty.

- Sahil Malik
http://www.winsmarts.com
http://blah.winsmarts.com
"William (Bill) Vaughn" <bi************ **@nwlink.com> wrote in message
news:O8******** ******@TK2MSFTN GP04.phx.gbl...
Excuse me? Are you accusing us of something? I would make pretty sure
you're on solid ground before impugning our honesty in a public forum. If
you really knew me, if you really understood where I have stood for the
last 20 years, you would not be saying anything about how I coddle
Microsoft or show bias toward their products. From time to time I have
been highly critical of Microsoft--even as an employee (for 14 years).
Microsoft has not always liked to hear what I have said, but they have
listened--just as they listen to every one with any credibility at all. I
for one have just finished my 11th book on this subject and yes, this book
like all the others talks about what works and what does not.

Do you think you fall into that category?

--
_______________ _______________ ______
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
_______________ _______________ ____

"ljh" <So**@where.els e> wrote in message
news:3C******** *********@bigne ws1.bellsouth.n et...
Of course you must....

"Sahil Malik [MVP C#]" <co************ *****@nospam.co m> wrote in message
news:u3******** ******@TK2MSFTN GP05.phx.gbl...
Well, both INETA speakers and MVPs are unbiased.

I'm an INETA speaker and MVP myself, and nearly don't have the same
pedigree as Bill Vaughn, but I must agree with his views on Microsoft.

- Sahil Malik
http://www.winsmarts.com
http://blah.winsmarts.com

"ljh" <So**@where.els e> wrote in message
news:ai******** ********@bignew s5.bellsouth.ne t...
"INETA Speaker" - at least you're unbiased.
"William (Bill) Vaughn" <bi************ **@nwlink.com> wrote in message
news:Om******** ******@TK2MSFTN GP04.phx.gbl...
> Ah SQL Express can be used with an IIS web site. SQL Everywhere
> cannot. It's not designed to do so but SQL Express (still free) is.
> Microsoft has done more for small business than any company I know. It
> now offers three versions of its database technology for free. SQL
> Everywhere, SQL Express and SQL Express Advanced Services that
> includes the Reporting Services engine as well as Full Text Search.
>
> If you just want to bash Microsoft, find some other forum.
>
> --
> _______________ _______________ ______
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> _______________ _______________ ____
>
> "ljh" <So**@where.els e> wrote in message
> news:_J******** ***********@big news3.bellsouth .net...
>> Awesome!
>>
>> It doesn't look like they'll let us use it to power webservices under
>> IIS though.
>>
>> That would suck. Allowing its use under IIS would make hosted web
>> development so much easier!
>>
>> It would let small companies with big ideas give those ideas a shot
>> at succeeding without spending several thousand dollars for SQL
>> Server.
>>
>> But, I don't think MS is all that interested in helping small
>> businesses grow. And, that's too bad. Doing so would actually
>> fatten the bottom line at MS as the little businesses need more MS
>> licenses and maybe a "grown up" version of SQL Server.
>>
>> If they did, who knows, it might even unseat MySQL as the web db
>> king.
>>
>> Thanks for the great link!
>>
>>
>>
>> "William Stacey [MVP]" <wi************ @gmail.com> wrote in message
>> news:Od******** ********@TK2MSF TNGP03.phx.gbl. ..
>>> Another option for you may be SQL Everywhere. I think will be
>>> released this
>>> summer. 1.4mb with 7 dlls.
>>> http://blogs.msdn.com/stevelasker/ar...whereInfo.aspx
>>>
>>> --
>>> William Stacey [MVP]
>>>
>>> "ljh" <So**@where.els e> wrote in message
>>> news:Dm******** ***********@big news3.bellsouth .net...
>>> |I mean that you can use Access databases simply by including the
>>> .mdb files
>>> | with your application, whereas using SQL Server Express requires
>>> that you
>>> | install SQL Server Express and have it running in the backgound.
>>> |
>>> | In the event that I use SQL Server Express and need to
>>> redistribute it
>>> with
>>> | my app, is there a silent install available?
>>> |
>>> | <ja**********@g mail.com> wrote in message
>>> | news:11******** **************@ u72g2000cwu.goo glegroups.com.. .
>>> | > Well, I'm not sure what you mean by "requires an installed
>>> application
>>> | > to work". I just downloaded it, ran the setup & it worked.
>>> And, since
>>> | > your reluctance to do that is the *ONLY* requirement you specify
>>> for
>>> | > your database needs, it's really hard to answer your question.
>>> | >
>>> | > So, the advantages of SQLExpress over Access, as I see them.
>>> | > 1) It's free.
>>> | > 2) It's directly compatible with Sql Server.
>>> | >
>>> |
>>> |
>>>
>>>
>>
>>
>
>



Jun 1 '06 #46
On Wed, 31 May 2006 20:34:56 -0400, "ljh" <So**@where.els e> wrote:
Of course you must....


Just curious...what are you getting out of this? Mr Malik and Mr
Vaughn have complete credibility and both have written books on
database programming. Still, you've answered your own question: You
should use Access. Just make sure it's not Microsoft Access cause
that would be bad.

Jun 1 '06 #47
ljh

"William (Bill) Vaughn" <bi************ **@nwlink.com> wrote in message
news:O8******** ******@TK2MSFTN GP04.phx.gbl...
Excuse me? Are you accusing us of something?
You accussed me, Billy. Remember this...."If you just want to bash
Microsoft, find some other forum."?

You take an accusatory tone with me. You attack my posts without reading
them (if you had, you'd have seen that the theme here was not one of "just
bashing Microsoft"). And, YOU have the audacity to ask me if I am
questioning YOUR integrity?

Well, I am questioning your integrity.

Not because I have reason to outside what you have posted here, but simply
because of the tact that you used when accusing me of "just bashing
Microsoft". That's something that only a Microsoft zealot could have
possibly read into this entire thread.

You are acting like a zealot. Your reaction to my dissappointment with
Microsoft's decision-to-date on SQL\e and the typical way in which they
price thier products out of reach of many small businesses was one of
etremism and showed a complete lack of understanding of my comments as they
related to the entire thread.

I accept you at your word that you call Microsoft out when need be (as
don't have time to verify this myself). But, for you to characterize my
entire thread as simple "Microsoft bashing" because I expressed my
unflattering opinions about some of Microsoft's actions is both
unprofessional and dishonest.

I am not familiar with your writings. They may be quite well done.
However, they are irrelevant when your actions here have shown you to be
quick to jump to conclusions of "Microsoft bashing" based on less than 10%
of the content of the thread.

Publishing a book niether makes you a scholar nor an adept teacher. It
makes you an author. My congratulations on your publishing feats. I hope
you published works better thought out than your biting response to a single
post of mine.

As for answering your question ("Do you think that you fall into that
category?")... This is both arrogant and ignorant at the same time. Quite
a feat for a published author.

I look forward to your thoughts on anything that I post. But, please do not
characterize me or my threads based on a minority of the postings therein.

Jim Hubbard
I would make pretty sure you're on solid ground before impugning our
honesty in a public forum. If you really knew me, if you really understood
where I have stood for the last 20 years, you would not be saying anything
about how I coddle Microsoft or show bias toward their products. From time
to time I have been highly critical of Microsoft--even as an employee (for
14 years). Microsoft has not always liked to hear what I have said, but
they have listened--just as they listen to every one with any credibility
at all. I for one have just finished my 11th book on this subject and yes,
this book like all the others talks about what works and what does not.

Do you think you fall into that category?

--
_______________ _______________ ______
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
_______________ _______________ ____

"ljh" <So**@where.els e> wrote in message
news:3C******** *********@bigne ws1.bellsouth.n et...
Of course you must....

"Sahil Malik [MVP C#]" <co************ *****@nospam.co m> wrote in message
news:u3******** ******@TK2MSFTN GP05.phx.gbl...
Well, both INETA speakers and MVPs are unbiased.

I'm an INETA speaker and MVP myself, and nearly don't have the same
pedigree as Bill Vaughn, but I must agree with his views on Microsoft.

- Sahil Malik
http://www.winsmarts.com
http://blah.winsmarts.com

"ljh" <So**@where.els e> wrote in message
news:ai******** ********@bignew s5.bellsouth.ne t...
"INETA Speaker" - at least you're unbiased.
"William (Bill) Vaughn" <bi************ **@nwlink.com> wrote in message
news:Om******** ******@TK2MSFTN GP04.phx.gbl...
> Ah SQL Express can be used with an IIS web site. SQL Everywhere
> cannot. It's not designed to do so but SQL Express (still free) is.
> Microsoft has done more for small business than any company I know. It
> now offers three versions of its database technology for free. SQL
> Everywhere, SQL Express and SQL Express Advanced Services that
> includes the Reporting Services engine as well as Full Text Search.
>
> If you just want to bash Microsoft, find some other forum.
>
> --
> _______________ _______________ ______
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> _______________ _______________ ____
>
> "ljh" <So**@where.els e> wrote in message
> news:_J******** ***********@big news3.bellsouth .net...
>> Awesome!
>>
>> It doesn't look like they'll let us use it to power webservices under
>> IIS though.
>>
>> That would suck. Allowing its use under IIS would make hosted web
>> development so much easier!
>>
>> It would let small companies with big ideas give those ideas a shot
>> at succeeding without spending several thousand dollars for SQL
>> Server.
>>
>> But, I don't think MS is all that interested in helping small
>> businesses grow. And, that's too bad. Doing so would actually
>> fatten the bottom line at MS as the little businesses need more MS
>> licenses and maybe a "grown up" version of SQL Server.
>>
>> If they did, who knows, it might even unseat MySQL as the web db
>> king.
>>
>> Thanks for the great link!
>>
>>
>>
>> "William Stacey [MVP]" <wi************ @gmail.com> wrote in message
>> news:Od******** ********@TK2MSF TNGP03.phx.gbl. ..
>>> Another option for you may be SQL Everywhere. I think will be
>>> released this
>>> summer. 1.4mb with 7 dlls.
>>> http://blogs.msdn.com/stevelasker/ar...whereInfo.aspx
>>>
>>> --
>>> William Stacey [MVP]
>>>
>>> "ljh" <So**@where.els e> wrote in message
>>> news:Dm******** ***********@big news3.bellsouth .net...
>>> |I mean that you can use Access databases simply by including the
>>> .mdb files
>>> | with your application, whereas using SQL Server Express requires
>>> that you
>>> | install SQL Server Express and have it running in the backgound.
>>> |
>>> | In the event that I use SQL Server Express and need to
>>> redistribute it
>>> with
>>> | my app, is there a silent install available?
>>> |
>>> | <ja**********@g mail.com> wrote in message
>>> | news:11******** **************@ u72g2000cwu.goo glegroups.com.. .
>>> | > Well, I'm not sure what you mean by "requires an installed
>>> application
>>> | > to work". I just downloaded it, ran the setup & it worked.
>>> And, since
>>> | > your reluctance to do that is the *ONLY* requirement you specify
>>> for
>>> | > your database needs, it's really hard to answer your question.
>>> | >
>>> | > So, the advantages of SQLExpress over Access, as I see them.
>>> | > 1) It's free.
>>> | > 2) It's directly compatible with Sql Server.
>>> | >
>>> |
>>> |
>>>
>>>
>>
>>
>
>



Jun 1 '06 #48
ljh wrote:
Just curious......ca n you tell me a situation where using XML as a
datatype would come into play in a database application?

Why would you store XML in its native format instead of breaking it
down into its component fields for storage and seaarch?
In general, people should avoid Xml typed fields to avoid
'table-in-table' syndrome, which effectively kills your relational
model. However there are situations where it can be helpful. One is the
situation where the user of your software is able to add custom fields
to a table. You can store these in XML and query them as well (although
it's not ideal, I admit)

Another can be to store xml data in an xml column, although you can
also use a Text column for that if you want to of course.

FB


"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamM>
wrote in message news:O6******** ******@TK2MSFTN GP02.phx.gbl...
Let's see:

Ability to do asynch apps (Service Broker)
Server model instead of file system model
Complete support for stored procedures
Full SQL Server security model
Ability to run queries as another user, completely isolating the
database from the user
Better support for types in SQL Server than Access (in .NET)
Ability to schedule backups within the engine
Support for more types than Access
Ability to use XML as a datatype with querying capabilities

Is that enough, or should I go on?

--
Gregory A. Beamer

*************** *************** *************** ****
Think Outside the Box!
*************** *************** *************** ****
"ljh" <So**@where.els e> wrote in message
news:kP******** ***********@big news3.bellsouth .net...
Why would you choose SQL Express (which requires an installed

application >> to work) over the simplicity of an Access database
which has no >> dependencies?

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
Jun 1 '06 #49
ljh wrote:

"William (Bill) Vaughn" <bi************ **@nwlink.com> wrote in
message news:O8******** ******@TK2MSFTN GP04.phx.gbl...
Excuse me? Are you accusing us of something?
You accussed me, Billy. Remember this...."If you just want to bash
Microsoft, find some other forum."?

You take an accusatory tone with me. You attack my posts without
reading them (if you had, you'd have seen that the theme here was not
one of "just bashing Microsoft"). And, YOU have the audacity to ask
me if I am questioning YOUR integrity?

Well, I am questioning your integrity.


I don't think that's beneficial to the discussion.
Not because I have reason to outside what you have posted here, but
simply because of the tact that you used when accusing me of "just
bashing Microsoft". That's something that only a Microsoft zealot
could have possibly read into this entire thread.
While Bill and I are often not agreeing on a subject, I can tell you
he's honest in what he says. He might have overreacted a bit in his
previous reply, but let me explain abit why I think he did and I fully
understand why he did: we as MVP's are often accused of being biased
towards Microsoft, shutting our eyes for the real problems, ignoring
the difficulties Joe Developer has to fight with because that would
hurt Microsoft etc. etc.

That's not the case, far from it. Sure, there are MVP's who only
preach 'good news' and won't say a bad word about MS or its products.
Though you won't find these MVPs in the newsgroups answering questions
of others. So please re-consider what you said.
You are acting like a zealot. Your reaction to my dissappointment
with Microsoft's decision-to-date on SQL\e and the typical way in
which they price thier products out of reach of many small businesses
was one of etremism and showed a complete lack of understanding of my
comments as they related to the entire thread.
Perhaps your 'packaging' of the 'message' wasn't matching the message
it was packaging :).
I accept you at your word that you call Microsoft out when need be
(as don't have time to verify this myself). But, for you to
characterize my entire thread as simple "Microsoft bashing" because I
expressed my unflattering opinions about some of Microsoft's actions
is both unprofessional and dishonest.
Read between the lines. We have to do that with your texts as well. If
I say "This SUCKS!!!", I might be right, but no-one will listen. Trust
me, if you want to get a point across, it's of upmost importancy that
the audience of which you want the attention of is willing to read your
texts to the last line.
As for answering your question ("Do you think that you fall into that
category?")... This is both arrogant and ignorant at the same time.
Quite a feat for a published author.


I have to agree in this, but this is usenet, we all forget everyone
can read what we say from time to time.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
Jun 1 '06 #50

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

72
3343
by: ljh | last post by:
Why would you choose SQL Express (which requires an installed application to work) over the simplicity of an Access database which has no dependencies?
0
9997
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9845
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11276
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10976
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9671
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8043
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7204
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5891
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6082
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.