Database Suggestions

[UofM Student]

I am currently using an Access database for my ASP page. At the most, 3
people will use that page at a time. On average, 1 person uses the page at
a given time. I thought using an Access database would have made things
simpler. It totally didn't. I am very disappointed with it. Sometimes I
get errors where there shouldn't be errors like, "Operation must use an
updateable query." I don't know if it's my IIS that sucks or the Access
database. I haven't reconfigured anything with respect to IIS. I just
installed it and left it as is. Was I supposed to do something here? Are
there any better alternatives that IIS. I head MySQL is a pain in the butt
and SQL Server is too expensive for the simple thing I want to do here.
SOMEONE PLEASE HELP!!

[Bob Barrows]

UofM Student wrote:

> I am currently using an Access database for my ASP page. At the
> most, 3 people will use that page at a time. On average, 1 person
> uses the page at a given time. I thought using an Access database
> would have made things simpler. It totally didn't. I am very
> disappointed with it. Sometimes I get errors where there shouldn't
> be errors like, "Operation must use an updateable query."

This is a ver common question. Here are two articles that cover it.
[url]http://www.aspfaq.com/show.asp?id=2009[/url]
[url]http://www.aspfaq.com/show.asp?id=2062[/url]


Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray at]

It's not IIS or Access that sucks. When you get these errors, there is a
reason for them, and IIS is being cool and informing you of the errors.
[url]www.aspfaq.com[/url] has a search feature. So does [url]http://support.microsoft.com[/url].
There is an answer to all of your problems, none of which "IIS sucks."

Ray at work

"UofM Student" <mrwatkin@umich.edu> wrote in message
news:OS2at8p5DHA.360@TK2MSFTNGP12.phx.gbl...

> I am currently using an Access database for my ASP page. At the most, 3
> people will use that page at a time. On average, 1 person uses the page

at

> a given time. I thought using an Access database would have made things
> simpler. It totally didn't. I am very disappointed with it. Sometimes I
> get errors where there shouldn't be errors like, "Operation must use an
> updateable query." I don't know if it's my IIS that sucks or the Access
> database. I haven't reconfigured anything with respect to IIS. I just
> installed it and left it as is. Was I supposed to do something here? Are
> there any better alternatives that IIS. I head MySQL is a pain in the

butt

> and SQL Server is too expensive for the simple thing I want to do here.
> SOMEONE PLEASE HELP!!
>
>

[Jeff Cochran]

On Thu, 29 Jan 2004 14:36:21 -0500, "UofM Student"
<mrwatkin@umich.edu> wrote:

>I am currently using an Access database for my ASP page. At the most, 3
>people will use that page at a time. On average, 1 person uses the page at
>a given time. I thought using an Access database would have made things
>simpler. It totally didn't. I am very disappointed with it. Sometimes I
>get errors where there shouldn't be errors like, "Operation must use an
>updateable query." I don't know if it's my IIS that sucks or the Access
>database. I haven't reconfigured anything with respect to IIS. I just
>installed it and left it as is. Was I supposed to do something here? Are
>there any better alternatives that IIS. I head MySQL is a pain in the butt
>and SQL Server is too expensive for the simple thing I want to do here.
>SOMEONE PLEASE HELP!!

It's not IIS or Access, it's your code. I doubt any change of
database will help, but MySQL works fine, and MSDE is the SQL data
engine with a free use license and some limitations you'd never
notice.

Start by posting the errors you get and we'll walk through them and
fix your code until Access works fine for you. Then you can decide if
you need to switch.

Amd for your first fix, see:

Why do I get database-related 80004005 errors?
[url]http://www.aspfaq.com/show.asp?id=2009[/url]

Jeff

[Roland Hall]

"Ray at <%=sLocation%>" wrote:
: It's not IIS or Access that sucks. When you get these errors, there is a
: reason for them, and IIS is being cool and informing you of the errors.
: [url]www.aspfaq.com[/url] has a search feature. So does
[url]http://support.microsoft.com[/url].
: There is an answer to all of your problems, none of which "IIS sucks."

Note: IIS_Sucks has been deprecated. Please use the new error message:
IIS_Blows
(it's a whole new direction) (O:=

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - [url]http://www.microsoft.com/technet/scriptcenter/[/url]
WSH 5.6 Documentation - [url]http://msdn.microsoft.com/downloads/list/webdev.asp[/url]
MSDN Library - [url]http://msdn.microsoft.com/library/default.asp[/url]

[Roland Hall]

"UofM Student" wrote:
: I am currently using an Access database for my ASP page. At the most, 3
: people will use that page at a time. On average, 1 person uses the page
at
: a given time. I thought using an Access database would have made things
: simpler. It totally didn't. I am very disappointed with it. Sometimes I
: get errors where there shouldn't be errors like, "Operation must use an
: updateable query." I don't know if it's my IIS that sucks or the Access
: database. I haven't reconfigured anything with respect to IIS. I just
: installed it and left it as is. Was I supposed to do something here? Are
: there any better alternatives that IIS. I head MySQL is a pain in the
butt
: and SQL Server is too expensive for the simple thing I want to do here.
: SOMEONE PLEASE HELP!!

There is an article dealing with the error IIS_Sucks and how to avoid it.
You can read about it here:
[url]http://microsoft.com@%6B%69%64%64%61%6E%67%65%72%2E%63%6F %6D/IIS_Sucks/[/url]

Good luck.
HTH...

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - [url]http://www.microsoft.com/technet/scriptcenter/[/url]
WSH 5.6 Documentation - [url]http://msdn.microsoft.com/downloads/list/webdev.asp[/url]
MSDN Library - [url]http://msdn.microsoft.com/library/default.asp[/url]