Using Access DB with Frontpage

[Guest]

Hi All,
I'm trying to hook my access database into my frontpage site. I was able to
connect the database and I can display data, I can even search for data, but
what I would like to do is be able to search for data in the database, then
update it when it is displayed. Is there an easy way to do this?

Thanks in advance,
David

 

[Ronx]

If you are using the wizards, take a look at the Database Interface
Wizard (FP2002 and FP2003).

In FP2003,
File->New
Click more website templates
Tick the box "Add to current Web site"
Change the location as appropriate
Highlight Database Interface Wizard
Click OK

 

[David Gibson]

Hi Ron

Thank you for this. I've created the pages you suggested, published them,
but how do I display these pages on-line? (I get error message when I use
http://www.eureka-tp.com/results_page.asp)

Thank you in advance

 

[Ronx]

http://www.eureka-tp.com/results_page.asp gives a 404 error - page not
found.

The Database Interface wizard usually places the results page in a
folder. If I chose to base the Wizard on the Galleries table in my
database the folder would be:

Database1_interface/Galleries

And the other related pages would be in

Database1_interface/Galleries/editor

Check to see where yours is actually set up.


--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

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

 

[David Gibson]

Thanks Ron. In fact, I moved them into the 'root' level.

However, I still don't get the option of editing the data and feeding this
back to the database. Are you able to help me with this please.

Thanks - David

 

[Kathleen Anderson]

I would start the DBIW over, and this time leave the pages where the wizard
puts them.

--

~ 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

 

[Ronx]

The submission form and results pages are working. The database editor
itself requires a username and password - I get the login page.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

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

 

[David Gibson]

With the database, I want users to update their own details so not sure I can
do it with Logins. I tried another way using:
http://www.frontpagemagic.com/DRW/Add-Edit-Delete/EditRecord/index.asp#Step1
but get stuck again - saving an edited record. The pages I created are:
www.eureka-tp.com/input.asp
www.eureka-tp.com/search.asp
www.eureka-tp.com/update.asp

Can you spot where I'm going wrong.

Thanks for your help so far - it's very much appreciated.
David

 

[Ronx]

What sort of information are your users going to update - if it includes
addresses/phone numbers then I would treat this as confidential, and
move away from the wizards.

With users able to update their own confidential information, you will
need a web application that:

Allows users to log in using a unique userId and password.
Retrieval of their own records based on userId and Password (NOT based
on their real names)
A mechanism for providing lost/forgotten passwords
A mechanism for changing passwords
(possibly) A secure server using https:// to open pages.

This is not a trivial task.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

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