asked on

Front Page and Access Databases

I am running Front Page 2000 and IIS3 on an NT4.0 SP5 Server.

I have created an access database with Access'97. I can't create a web page to display the content of the database.

When I browse the page in IE5 or Netscape 4, all I get are the table headings.

Is there anywhere I can get step by step instructions to walk me through installation of all required components and creation of a sample web page to browse a database?

Member_2_242555

Look at the MSDN Microsoft developers network, if you suscribe you will get two cd's wirh the Knowledge Base.

then you have two choices:

a) Try getting Active server pages SDK and buuild an applet that will connect via ODBC with you database so you will have querys on demand. There are samples in the ASP CD.

b) You can design a Report that, then you can export thatreport to HTML

NickRackham

leon,

mail me at nick_rackham@msn.com and I'll mail you back a sample database with html and asp pages that show you how to create pages that update insert delete records in a database plus how to display tables to your requiremants on a web page.

Regards

Nick

NickRackham

sorry, that comment was addressed to akb not leon. My mistake.

akb

ASKER

Thanks for the comments. I would like to keep the question open for a while for further comment.

SiteSee

Are you certain you have data entered into your database...you would, of course only see headings if that were the case...
make sure you're SQL query is really hitting the Table..Field you want..if you see the table headings...and they are actually dynamically being written from the database, and not "hand-typed" on the page, you're query is working.

Steve

zs6phd

Have you created an html front-end using Access 97, or are you trying to use FP 2000 to access the Access database?
If the latter, you can add some neat asp code to your pages to give you much better control. If you like this idea, please post a message and I will provide sample code and some useful links.

Peter

akb

ASKER

I've tried using both methods. I am interested in anything that may help.

I didn't "hand'type" the headings. If I expand the data area of the table on the html page in FrontPage, when I view the page in a browser, the headings are stretched to fill the data area. If I preview the page in FrontPage, this does not happen. I have tested using IE5 & Netscape 4.5.

SiteSee

Well then those "headings are being "pulled" from your database...which means the query(as you have it written) WORKS...
There is either NO DATA in the database to display, or your object references in your template page are not written correctly...
e.g.
<%response.write((rs.fields("YourDatabaseFieldName")))%>

Steve

akb

ASKER

Hello SiteSee, I am VERY new at web development, so I don't really know what I am doing.

I don't think the Front Page manual or Help tells me anywhere that I need to write template pages.

I really think I need step-by-step instructions. Is there anywhere on the www that will provide me with this?

Thanks,

akb

SiteSee

This is a tutorial for creating a dynamically driven product database...
it assumes, though, that you have downloaded and are working with the sample database that comes with the SalesCart shopping cart software(free demo)...
http://www.salescart.com/support/tn-003.htm

....it is a step-by-step tutorial on building a dynamic product site with FrontPage and Access

hope this helps...

Steve

akb

ASKER

NickRackHam, please post an answer and claim the points.
Thanks for all the help.

ASKER CERTIFIED SOLUTION

NickRackham

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial