Using Access DB with Frontpage

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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
 
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
 
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
 
Back
Top