View Form Data in Access Database?

[salsweb]

After i fill out my form to test it, the confirmation comes up and it seems
to work just fine. But i cant figure out how to view the results in the
access database?

 

[Kathleen Anderson]

You can create a page to query the database with the FrontPage Database
Results Wizard. Create a page with a .asp extension and then Insert >
Database Results.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[salsweb]

that helps some. but what exactly do i do once i get into access

 

[Kathleen Anderson]

Well, the instructions I gave you were for FrontPage, not for Access. If you
have a form in your web site that is writing to an Access database in your
web, the Database Results Wizard will let you look at that database while
it's in your web site.

If you want to look at the data using the Access application, export the
database from your web site to your desktop (File > Export - it should be in
the fpdb folder). Once it's on your desktop, double-click it and it will
open in Access. Click on the Table and it will open.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[salsweb]

Hi. sorry for being so difficult. Well ok i got access to work (since thats
where it automatically goes to), it shows all the fields of the form at the
top, just not the results

 

[Ronx]

Sounds like permissions on the fpdb folder are incorrect. The easiest
way to correct this (usually works) is to import a new database into the
website.

Open the live website in FrontPage (*not* the copy on your own PC).
Create a new database in Access. You can use the database you exported
from the website earlier, but give it a new name.
In FrontPage, use File->Import - Add File and browse to the new
database.
Click OK
FrontPage will ask if you wish to import the database into the fpdb
folder - say Yes
The new database will be imported, and usually the permissions are
changed to the correct settings.
You can now delete the imported database.

Kathleen's suggestion for the Database results page should be followed -
using this page in the browser will enable testing the form and database
insertion more easily than exporting the database and firing up Access.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp