Edit Your Data Information

[frontpagecustoms.com]

I want to allow users to edit information stored in my database.
However I have not found a way in FrontPage 2003 to allow this. Where
sort of code/programming is required to make this happen?

 

[Kathleen Anderson [MVP - FrontPage]]

What kind of database is it and what kind of server is your web site hosted
on?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[frontpagecustoms.com]

It's a Access Database on a 1and1 Microsoft Server.

 

[Kathleen Anderson [MVP - FrontPage]]

FrontPage 2003 has the Database Interface Wizard that will let you create
pages to add, change and delete records in your database.
http://office.microsoft.com/en-us/frontpage/HP010531651033.aspx

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[frontpagecustoms.com]

What I'm looking for is the ability to have users call up their
information to edit and re-submit. I've found a way to have their info
display and edit a current record in a text field. however when they
hit submit it saves it as a new record. I want it to replace the
current record. I'm not sure if this is a part of the database
results wizard, a form, or additional scripting.

Thanks.

 

[Kathleen Anderson [MVP - FrontPage]]

You can do this with the Database Interface Wizard. You will probably need
to customize it to add a login process that only allows them to edit their
own record.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

What I'm looking for is the ability to have users call up their
information to edit and re-submit. I've found a way to have their info
display and edit a current record in a text field. however when they
hit submit it saves it as a new record. I want it to replace the
current record. I'm not sure if this is a part of the database
results wizard, a form, or additional scripting.

Thanks.

FrontPage 2003 has the Database Interface Wizard that will let you create
pages to add, change and delete records in your
database.http://office.microsoft.com/en-us/frontpage/HP010531651033.aspx

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/

It's a Access Database on a 1and1 Microsoft Server.

On Jan 16, 8:04 pm, "Kathleen Anderson [MVP - FrontPage]"
What kind of database is it and what kind of server is your web site
hosted
on?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/

messagenews:[email protected]...

I want to allow users to edit information stored in my database.
However I have not found a way in FrontPage 2003 to allow this.
Where
sort of code/programming is required to make this happen?

 

[frontpagecustoms.com]

Thanks. I can't believe I was confusing the Interface Wizard with the
Results Wizard. I didnt' even know that existed. However I'm getting
this error message on the "update.asp" page after submitting changes in
the "edit.asp" page.

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

Please advise.

You can do this with the Database Interface Wizard. You will probably need
to customize it to add a login process that only allows them to edit their
own record.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/

What I'm looking for is the ability to have users call up their
information to edit and re-submit. I've found a way to have their info
display and edit a current record in a text field. however when they
hit submit it saves it as a new record. I want it to replace the
current record. I'm not sure if this is a part of the database
results wizard, a form, or additional scripting.

Thanks.

FrontPage 2003 has the Database Interface Wizard that will let you create
pages to add, change and delete records in your
database.http://office.microsoft.com/en-us/frontpage/HP010531651033.aspx
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/
message
It's a Access Database on a 1and1 Microsoft Server.
On Jan 16, 8:04 pm, "Kathleen Anderson [MVP - FrontPage]"
What kind of database is it and what kind of server is your web site
hosted
on?
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/
message
I want to allow users to edit information stored in my database.
However I have not found a way in FrontPage 2003 to allow this.
Where
sort of code/programming is required to make this happen?

 

[Stefan B Rusynko]

Post your sql code
For details on 80040E14 errors
See http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040e14-errors.html

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Thanks. I can't believe I was confusing the Interface Wizard with the
| Results Wizard. I didnt' even know that existed. However I'm getting
| this error message on the "update.asp" page after submitting changes in
| the "edit.asp" page.
|
| Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
|
| Please advise.
|
|
| On Jan 17, 4:29 pm, "Kathleen Anderson [MVP - FrontPage]"
| > You can do this with the Database Interface Wizard. You will probably need
| > to customize it to add a login process that only allows them to edit their
| > own record.
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web:http://www.spiderwebwoman.com/resources/
| >
| >
| > > What I'm looking for is the ability to have users call up their
| > > information to edit and re-submit. I've found a way to have their info
| > > display and edit a current record in a text field. however when they
| > > hit submit it saves it as a new record. I want it to replace the
| > > current record. I'm not sure if this is a part of the database
| > > results wizard, a form, or additional scripting.
| >
| > > Thanks.
| >
| > > On Jan 17, 2:22 pm, "Kathleen Anderson [MVP - FrontPage]"
| > >> FrontPage 2003 has the Database Interface Wizard that will let you create
| > >> pages to add, change and delete records in your
| > >> database.http://office.microsoft.com/en-us/frontpage/HP010531651033.aspx
| >
| > >> --
| >
| > >> ~ Kathleen Anderson
| > >> Microsoft MVP - FrontPage
| > >> Spider Web Woman Designs
| > >> web:http://www.spiderwebwoman.com/resources/
| >
| > >> message| >
| > >> > It's a Access Database on a 1and1 Microsoft Server.
| >
| > >> > On Jan 16, 8:04 pm, "Kathleen Anderson [MVP - FrontPage]"
| > >> >> What kind of database is it and what kind of server is your web site
| > >> >> hosted
| > >> >> on?
| >
| > >> >> --
| >
| > >> >> ~ Kathleen Anderson
| > >> >> Microsoft MVP - FrontPage
| > >> >> Spider Web Woman Designs
| > >> >> web:http://www.spiderwebwoman.com/resources/
| >
| > >> >> message| >
| > >> >> >I want to allow users to edit information stored in my database.
| > >> >> > However I have not found a way in FrontPage 2003 to allow this.
| > >> >> > Where
| > >> >> > sort of code/programming is required to make this happen?
|