ASP and Access Databases

My web-packaged training pieces (using Authorware) send data to an Access
database via ASP pages. In the past, I have tested the files using the
version of Microsoft IIS that came with my Win XP Pro. It worked great.
Now, I am having trouble.

The files that ran 6 months ago no longer run successfully. When I run a
web packaged file that reads a record that's in the database, the command
returns error 5006 (not defined). The training, ASP and Access files are in
the folder ASPTest. This folder's properties display a green indicator for
Read-Only. If I remove the indicator, close properties and reopen
properties, the green indicator reappears.

I suspect these causes: the latest Win XP update, the Win XP firewall, and
file attributes and permissions. I manipulate these items but an unable to
succesfully run the web-packaged READ file. I have also reloaded Microsoft
IIS. Any suggestions on what I might try next? Any test files that I can
run to establish a base of success?

Thanks.

Jim

Re: ASP and Access Databases

The first thing to try is to use an HTML form to call the ASP page. Send the
same data that you would from the AW piece. If you get an ASP error message
post it here. If not, make sure you are using the same URL in your AW piece.
If that doesn't help post the AW script code on the Authorware site.

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"James_101" wrote in message
news:E07490DA-2DB5-480E-88E5-EEB34418CB59@microsoft.com...
> My web-packaged training pieces (using Authorware) send data to an Access
> database via ASP pages. In the past, I have tested the files using the
> version of Microsoft IIS that came with my Win XP Pro. It worked great.
> Now, I am having trouble.
>
> The files that ran 6 months ago no longer run successfully. When I run a
> web packaged file that reads a record that's in the database, the command
> returns error 5006 (not defined). The training, ASP and Access files are
> in
> the folder ASPTest. This folder's properties display a green indicator
> for
> Read-Only. If I remove the indicator, close properties and reopen
> properties, the green indicator reappears.
>
> I suspect these causes: the latest Win XP update, the Win XP firewall,
> and
> file attributes and permissions. I manipulate these items but an unable
> to
> succesfully run the web-packaged READ file. I have also reloaded
> Microsoft
> IIS. Any suggestions on what I might try next? Any test files that I can
> run to establish a base of success?
>
> Thanks.
>
> Jim

Re: ASP and Access Databases

Thanks Mark. I'm unsure how to write an HTML form to call the ASP page. Can
you give me a ref to go to?

Thanks.

Jim

"Mark Schupp" wrote:

> The first thing to try is to use an HTML form to call the ASP page. Send the
> same data that you would from the AW piece. If you get an ASP error message
> post it here. If not, make sure you are using the same URL in your AW piece.
> If that doesn't help post the AW script code on the Authorware site.
>
> --
> --Mark Schupp
> Head of Development
> Integrity eLearning
> www.ielearning.com
>
> "James_101" wrote in message
> news:E07490DA-2DB5-480E-88E5-EEB34418CB59@microsoft.com...
> > My web-packaged training pieces (using Authorware) send data to an Access
> > database via ASP pages. In the past, I have tested the files using the
> > version of Microsoft IIS that came with my Win XP Pro. It worked great.
> > Now, I am having trouble.
> >
> > The files that ran 6 months ago no longer run successfully. When I run a
> > web packaged file that reads a record that's in the database, the command
> > returns error 5006 (not defined). The training, ASP and Access files are
> > in
> > the folder ASPTest. This folder's properties display a green indicator
> > for
> > Read-Only. If I remove the indicator, close properties and reopen
> > properties, the green indicator reappears.
> >
> > I suspect these causes: the latest Win XP update, the Win XP firewall,
> > and
> > file attributes and permissions. I manipulate these items but an unable
> > to
> > succesfully run the web-packaged READ file. I have also reloaded
> > Microsoft
> > IIS. Any suggestions on what I might try next? Any test files that I can
> > run to establish a base of success?
> >
> > Thanks.
> >
> > Jim
>
>
>

Re: ASP and Access Databases

any HTML reference will include it. Look for a section on forms. Here is a
simple example: