Creating A form on a webpage to update a Access Database...

[Guest]

I have been trying unsucessfully for the last month or two to create a form
that would update a access database (running both FP 2000 and Access 2000).
Then I want to be able to set it up to where people can search within the
database (ex. Like a online phone directory). I have found that updateing
the Database Directly through access causes problems with the database
results search page, so know I am trying to find out how to set up a form on
the web that will let me update, delete, and add new records to the database.
Any help would be very helpful. Thanks

Stacie

 

[Andrew Murray]

if you have ASP, IIS, a windows server and the frontpage server extensions you
can do this through the Database Interface Wizard.

 

[Guest]

Yes I know and that would be the easiest way only I am running Frontpage 2000
and am not able to update. And frontpage 2000 didn't come with this Wizard
any other ideas.

thanks
Stacie

 

[Andrew Murray]

Frontpage 2000 should come with the the Database Results Wizard then. (not the
"interface" wizard).

Try this free updating tool I found:

http://www.standardreporting.net/1ClickDB/

Use it to add records, edit and delete records- written in ASP - needs
IIS/Windows or ASP/Unix (don't know if it works on this).

Supports Access, MySql, Oracle, Excel, Sql Server databases. All you do to
connect to the db to edit is put in the path to the DB on your server. You can
password protect it if it's in a protected directory e.g. outside your "home"
directory - some ISP's/Hosts do this so the db is not browsable, but is
accessible by the scripts.

 

[Clark]

Stacie, have you tried updating your database locally, and then just
ftp'ing the updated database to your website? As long as you arent
changing the structure of the database itself but just doing something
like addiing or editing records, replacing an Access database or your
site with an updated one via ftp will cause no problems with existing
searches.