Access and Frontpage

[islandlover]

Is it possible to use a form created in Access on a frontpage web site where
visitors can enter data in the form and it is transferred back to the
database or is it necessary to design the page in frontpage?

Thanks for your help.

 

[Ronx]

It is necessary to design the form in FrontPage, and use an asp or
asp.net form handler to add the form data to the Access database.

 

[David Berry]

You can design it in FrontPage and then use either ASP, ASP.NET or the
FrontPage Database Wizard (see
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for tips) to
write to the database.

 

[Stefan B Rusynko]

If your ASP is getting the form field (say named "Comments") as
Comments = Request.Form("Comments")
You can restrict it in ASP using
IF Len(Request.Form("Comments"))>400 Then
Left(Request.Form("Comments"),400)
Else
Request.Form("Comments")
End If

You can not restrict the size of a Memo field in Access

--

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


| To add to your query
|
| I have such a system on my website. The Database has a memo field & I have
| set up a form for visitors to use & enter their comments in the DB memo
| field. The form restricts inputting more than 400 character. But some smart
| users bypass this form & make an entry directly in the DB memo field putting
| in more than 400 characters.
| I have heard of Server side form validation but dont know how to set it up.
| could some one help?
|
| "islandlover" wrote:
|
| > Is it possible to use a form created in Access on a frontpage web site where
| > visitors can enter data in the form and it is transferred back to the
| > database or is it necessary to design the page in frontpage?
| >
| > Thanks for your help.