Access Frontpage Access Database Troubles

Joined
Nov 16, 2007
Messages
1
Reaction score
0
Hello~ This is my first post. Please bear with me as I attempt to explain my problem. Im running fp2003, have created a database, my web.config & global.asa files are in the root. I've created a database using DIW, asp.net & access (as provided by my host - Network Solutions). I have a couple issues:
1. When I run the fpselect.asp, I get the following msg.
Global.asa successfully fired
The global.asa that was fired is inside of this Web.
This means that this Web is an application root.


FrontPage Database Test Page
Microsoft PSS


1. Select the name of the connection that is defined in FrontPage for your database.
2. Enter the name of a table in your database.
3. Enter a username and password only if necessary for your connection.
4. Click "Execute Query" to query the database.


You are authenticated as: Web not browse-restricted. FrontPage Connection: promoappl Sample Table to Display: RequiredUsername:Password:

This is a wonderful tool but I don't know what to enter into the Table to Display required text box? When I created the database I don't recall naming the table. I've read through a book called A Special Edition, Using MS Office FP2003. Unless I've missed something I don't see where I choose a name for the table.


2. When I go to my url of the submission page, editor page, submissions page, or results page, I get the same message.

Server Error in '/PromoAppl' Application.

Runtime Error

[font=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

<!-- Web.Config Configuration File --><configuration> <system.web> <customErrors mode="Off"/> </system.web></configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

<!-- Web.Config Configuration File --><configuration> <system.web> <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/> </system.web></configuration>[/font]
I have added this file "mycustompage.htm" and the code suggested on the bottom but still the same message. I know my database is connected as it verifies but I'm stuck as what to do next. Any help at all will be greatly appreciated. I've been working on this about 2 weeks now and my notebook has almost become a frisbee a few times.


Thanks in Advance
 
Back
Top