Software

Ask something
Discussion Locked

FrontPage Database

0 helpful
6 replies

by john murray 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have created a form with FrontPage 2000 and published it to my web server(NT 4.0 SP6a, IIS 4.0, with Frontpage Server Extensions). When I run the form and type in some data it is supposed to save that data to an Access database. However when I check the database it is empty. The correct fields are there but no data. Has anyone had this problem?

6 replies

by gutridgesj

without seeing the form, which would help, is the access database on the same server as IIS, or a mapped drive on the network?

seeing the form and knowing where the access db is located would help to answer the question.

by gutridgesj

also, is their an odbc entry and what does the odbc entry on the iis server say? and is that what is referenced in the form?

by john murray

the form is just a generic form that comes with FrontPage. Frontpage creates the Access database all by itself and places it in a subdirectory called fpdb. When the web page is published to the server the database goes with it and stays with it. There is no ODBC entry as this does not require one since it is not an SQL server or Oracle database for example.

by amielzz

Whenever you open an Access database, an '.ldb' file is created (in the same directory) and since most folders/directories on web sites are 'read only', using Access can be cumbersome.

You'll have to permit your IUSR_ account to have read/write access to the folder where the Access .mdb resides. Once done your forms
should work fine.

ah, the permissions will have to be set using NT.

by john murray

Working directly with Microsoft, I found that my web site was working just fine. The problem was with the form that I was using. Mind you, it was a form that was created by Microsoft and came with Front Page. I did not take the time to troubleshoot it further, I just decided to create a new form from scratch.

This discussion is closed to new replies.