re:
In fact, VS 2005 ships by default with the SQLEXPRESS providers
True, although there's an Access Providers Starter Kit :
http://msdn.microsoft.com/asp.net/downloads/providers/
re:
MS Acccess is no longer used.
It's used a lot more than your statement indicates, Peter,
particularly at the beginner developer level who has low traffic sites.
re:
My point is, lots of people are still hung up on Access from the "old days"
I wouldn't say "hung up", but -maybe- "still using", but that's not all that bad.
I remember having a finely tuned website which used Access and could
serve over 50 concurrent requests without breaking a sweat.
Most small sites only get 2-10 concurrent requests.
re:
in most cases, they need to be encouraged to graduate to the next level.
I heartily agree with that, however we should not be locking them out.
"Encouraging" should mean just that : encouraging, not obliging.
btw, with the above linked Access Providers Toolkit, plus a sql-to-Access tool, found at
http://www.google.com/search?num=20&...=sql-to-access
it shouldn't be too hard to use an Access database, instead of SQL Express 2005,
if there's unsurmountable constraints which prevent the use of SQL Express 2005.
Finally, I agree that SQL Server 2005 is the way to go.
I just like all options to be available and not making developers upgrade obligatorily.
best regards,
Juan T. Llibre, asp.net MVP
aspnetfaq.com :
http://www.aspnetfaq.com/
asp.net faq :
http://asp.net.do/faq/
foros de asp.net, en español :
http://asp.net.do/foros/
===================================
"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.comwrote in message
news:FB**********************************@microsof t.com...
Ken,
This is true. However, the OP did not post anything to infer that an ISP /
Hoster was even involved. In fact, VS 2005 ships by default with the
SQLEXPRESS providers, MS Acccess is no longer used. My point is, lots of
people are still hung up on Access from the "old days" and in most cases,
they need to be encouraged to graduate to the next level.
Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com
"Ken Cox [Microsoft MVP]" wrote:
>Not all ISPs support SQL Express, so some people are forced to use Access.
"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.comwrote in message
news:34**********************************@microso ft.com...
Recommendation: Don't do it. SQLExpress is free, and that's the full SQL
SERVER 2005 engine. Let MSAccess die a natural death, please!
Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com
"Lero" wrote:
how could I use MS access database insted of SQL server?