Access Database Form

20 Nov 2004 7:53 PM

data cruncher

I have an Access database created, complete with input forms. I would like to
include this on my FrontPage based website, so that employees may use it to
add information to the database. I have uploaded the Access Database file to
the website. Is there a way to use the form that I have already created in
Access (it is quite complicated, and very nice looking)? Or do I *have* to
create a FrontPage generated form, and then link that to the database?

20 Nov 2004 9:45 PM

Kathleen Anderson [MVP - FrontPage]

If you plan on using the FrontPage Database Wizard, you can only use the
tables and queries in the database.

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

data cruncher <datacrunc***@discussions.microsoft.com> wrote:

Show quote

> I have an Access database created, complete with input forms. I would
> like to include this on my FrontPage based website, so that employees
> may use it to add information to the database. I have uploaded the
> Access Database file to the website. Is there a way to use the form
> that I have already created in Access (it is quite complicated, and
> very nice looking)? Or do I *have* to create a FrontPage generated
> form, and then link that to the database?

23 Nov 2004 10:47 PM

Ravi Anguluri

Hi,
You could try this. Copy the mdb file in to a folder inside the frontpage
web or use import, usually in fpdb folder and create a new connection
pointing to this database. Create a FrontPage form with textbox names which
match the field names in the table. Right click in the form, select send to
database. Click option button, select the database connection to use and
table to hold results.

Hope this Information helps.
Regards
Ravi
MSFT

This posting is provided "as is" with no warranties and confers no rights
--------------------
Show quote

>Reply-To: "Kathleen Anderson [MVP - FrontPage]" <spiderwebwo***@mvps.org>
>From: "Kathleen Anderson [MVP - FrontPage]" <spiderwebwo***@mvps.org>
>Subject: Re: Access Database Form
>Newsgroups: microsoft.public.frontpage.programming
>
>If you plan on using the FrontPage Database Wizard, you can only use the
>tables and queries in the database.
>
>--
>~ Kathleen Anderson
>Microsoft MVP - FrontPage
>Spider Web Woman Designs
>web: http://www.spiderwebwoman.com/resources/
>blog: http://msmvps.com/spiderwebwoman/category/321.aspx
>
>
>
>data cruncher <datacrunc***@discussions.microsoft.com> wrote:
>> I have an Access database created, complete with input forms. I would
>> like to include this on my FrontPage based website, so that employees
>> may use it to add information to the database. I have uploaded the
>> Access Database file to the website. Is there a way to use the form
>> that I have already created in Access (it is quite complicated, and
>> very nice looking)? Or do I *have* to create a FrontPage generated
>> form, and then link that to the database?
>
>