inserting an access database into frontpage

T

trey braid

can someone please tell me how to insert an access database in frontpage.... please advse...
thanks
trey
im using office 2003...
 
T

Thomas A. Rowe

If the database is already created, then just import it into your current open FP web / site, FP
will prompt you to create a connection and the to allow the database to be moved to the fpdb folder,
let it do this. Then you can use the Database component to display data from the database or you can
create forms that will allow you to add, edit or delete data from the database, additional info is
available under Help.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
B

Bill Schroyer

Choose > File > Import - Point to your db. Let FrontPage
make a connection to it and put it in fpdb folder. Now
Create a from and link to it or Run the database results
wizard >Insert > Database


Bill Schroyer
[email protected]
http://www.frontpagewiz.com
-----Original Message-----
can someone please tell me how to insert an access
Click to expand...
database in frontpage.... please advse...
 
A

Andrew Murray

it can also create the DB for you based on the form fields in your form that you
will be submitting the data from.

or else it can source the records from other sources like excel files
 
T

trey braid

once i try and import it goes to the import site wizard and give's me 5 choices's
frontpage...webdav..ftp...file system...http... now i know file system is what i want to choose ( i think ) cause the access database is a table for my report's.... for infopath activity...it dsnt give me an opportunity to find the database....what am i doing wrong... do i have to type out the location of the file to import ? plz advse....
 
J

John Jansen \(MSFT\)

You get that dialog when you are authoring only a page, not a web site.
First thing you need to do is click on File > New and create an actual web
site using the one page template (you can use any template, but one page is
probably easiest).

Then click on File > Import and browse to your Access database, allow
FrontPage to create the fpdb folder for you, and then create a new page.

Click on Insert > database > results, and you will see the connection
FrontPage just created for you available. Select it, and then go through
the wizard to create a Database Results region.

Now, if you created your site on your C:\ drive, you will not be able to
actually see the data, because the results require ASP, which requires you
author on a server. But, once you publish your site to your server, you
should be able to see all the database content.

If you want to get more complex, check this out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;287993
 
Top