Re: updating database

From: Harddrive747 (Harddrive747_at_discussions.microsoft.com)
Date: 10/12/04 

Date: Tue, 12 Oct 2004 10:51:06 -0700

Thomas, that is what I do to test the pages. I understand the permissions
issue and I guess that would mean on the directory that it might be read
only. I will have to make sure that the directory and the database are
writeable.

You said "application root is not set on the web root or subweb/subsite."
Can you please expand on this and let me know where this needs to be set and
what it needs to be set to.

Thanks.

"Thomas A. Rowe" wrote:

> The file format of Access 97 is totally different from Access 2000 and Access 2002/2003. If using
> FP2003, then it will create a Access 2003 database.
>
> To test your ASP, you must either test it via http://localhost on your PC via your browser or after
> publishing to Windows IIS web server via your browser. When data is not written to the database,
> that indicates a permission issue or the application root is not set on the web root or subweb /
> subsite.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Harddrive747" <Harddrive747@discussions.microsoft.com> wrote in message
> news:49DED614-991A-4225-8713-EA8230488648@microsoft.com...
> > Thomas thanks for the information, but as I stated, I told FP to create a new
> > database and attempted to update it. I then queryed that database and
> > nothing got stored in it. This is all in web design.
> >
> > I personally don't see why I should have to upgrade to Access 2003 when I'm
> > using an Access database. Isn't the core of Access database the same?
> >
> > Looking forward from hearing back from you.
> > Terry
> >
> > "Thomas A. Rowe" wrote:
> >
> > > Suggest that you let FP create the database, as the problem could be with the fact that you are
> > > using Access 97 which you will need to upgrade to Access 2003 to view the database created by
> > > FP2003.
> > >
> > > --
> > > ==============================================
> > > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > > WEBMASTER Resources(tm)
> > > http://www.ycoln-resources.com
> > > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > > ==============================================
> > > To assist you in getting the best answers for FrontPage support see:
> > > http://www.net-sites.com/sitebuilder/newsgroups.asp
> > >
> > > "Harddrive747" <Harddrive747@discussions.microsoft.com> wrote in message
> > > news:E8326B5C-9BBE-4F12-BCAE-DADBE102657F@microsoft.com...
> > > > I have just purchased FrontPage 2003. I have been able to get information in
> > > > a database to print out in a web page. So I have no problem with that.
> > > >
> > > > Here is the issue. I have created a submission forms web page and set it up
> > > > to update the database that I am working with. I put all the form fields in
> > > > and I tell the form to save the results of the form to a database. I specify
> > > > the database, I map the form fields to the column fields and click ok.
> > > >
> > > > I then run the page and I type in all the information and click on the
> > > > submit button and it looks like it work and it gives me a confirmation page
> > > > and then I go back to the orignial page. I then look in the database and
> > > > nothing was added to my table.
> > > >
> > > > I have Access '97 and FrontPage 2003. I have tried this with FrontPage
> > > > creating a database and it still does not save the value of the field in the
> > > > database.
> > > >
> > > > So the question is what am I doing wrong? What do I need to do to get it to
> > > > work?
> > > >
> > > > Thanks for the help and if you need more information let me know
> > > >
> > > > Thanks
> > > > Terry
> > >
> > >
> > >
>
>
>