Amen to that!!!
I have built many ASP websites using mdb backends and have had downtime. I
haven't even tried it with ASP.NET because I learned EARLY. If you open the
database and try to modify it, users will "sometimes" get a "Page cannot be
displayed" error because you have the database locked. In early versions of
IIS, closing the database would still not release the locks for some reason.
The only way I could get it back online was to stop IIS and copy, then
rename the mdb, then restart IIS - unbelievable... so... I resorted to
copying the thing elsewhere, modify it as fast, then replace the production
mdb. Hopefully, you are not collecting data while this is going on or else
it would obviously be lost. Sure, you could import some of the changes, but
geez...
On both mdb releases I had instances where ISP administrators did a blanket
permission assignment and gave all web files "read only" thinking that they
were "just html files". That certainly doesn't set well with a mdb.
Using Sql Server is wonderful, I have dozens of sites running with it and
wouldn't think twice about changing anything. Once you set up the
permissions and connection string, it's very unlikely you will ever have to
look at that again unless the entire server changes somehow.
But really, too many Access things like this to list... small database or
large, this is Access and you pay with frustration for keeping things simple
with one little mdb.
--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access
"Hermit Dave" <he***********@CAPShotmail.com> wrote in message
news:uw***************@tk2msftngp13.phx.gbl...
Well the reason is simple... access is limited to what it can do how much
data it can hold.... and isnt very good when you are talking of multi user
connectivity...
i have had so many issues... i reckon others have had similar issues in
past
thats about all thats wrong with access...
HD
"John" <jo**@nospam.infovis.co.uk> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl... Thanks for that. Why does everyone hate access?
"Hermit Dave" <he************@CAPS.AND.DOTS.hotmail.com> wrote in
message news:ei**************@TK2MSFTNGP09.phx.gbl... dont know bout developing with access but try www.asp.net it should be
a good starting point. There you will find a whole lot of tutorials and
links to other sites which might be helpful.
HD
"John" <jo**@nospam.infovis.co.uk> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
> Hi
>
> Is there an asp.net sample site with access backend that I could use
to > learn good asp.net development practices?
>
> Thanks
>
> Regards
>
>
>
