1) FP Database abilities 2)How to add ASP code using FP?

[Will]

Using FP2003.

I'm going to be working on code for using a Microsoft Access database online
and using ASP to do it.

1 - How can I put ASP code in Front Page and have it not change the code?

2 - Will Front Page 2003 automatically create the "Conection" code for me?
(Maybe it will save me some work

3 - Will FP automatically create pages to retreive data from the data base
for me or must I hand code it with ASP?

4 - Will FP automatically create pages to add new records or edit data ?

5 - How to handle this?

Logging on with an FTP program I see our ISP has two folders on our site...
"www" has the Front Page pages in it.
"data" has the Access file in it... OurData.mdb

How can I get FP to work in both folders if I use FP to create the data base
pages?

Thanks for any help.

 

[Ronx]

Comments Inline below.

--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp

FrontPage Support: http://www.frontpagemvps.com/

Using FP2003.

I'm going to be working on code for using a Microsoft Access database online
and using ASP to do it.

1 - How can I put ASP code in Front Page and have it not change the code?

Carefully. Example: Do not start a table in script and finish it in
HTML or vice versa.
I have not known FP to change any of my HTML or vbScript in .asp pages.

2 - Will Front Page 2003 automatically create the "Conection" code for me?
(Maybe it will save me some work

Yes - if you File->Import the database into the open website FrontPage
will save it in the fpdb folder, set the correct permissions for the
folder, and set up a connection string in the global.asa. None of this
will be done if you don't use File->Import (unless you use a wizard to
create the database).

3 - Will FP automatically create pages to retreive data from the data base
for me or must I hand code it with ASP?

Check the Database Results Wizard.

4 - Will FP automatically create pages to add new records or edit data ?

Check the Database Results Wizard and Database Interface Wizard

5 - How to handle this?

Logging on with an FTP program I see our ISP has two folders on our site...
"www" has the Front Page pages in it.
"data" has the Access file in it... OurData.mdb

How can I get FP to work in both folders if I use FP to create the data base
pages?

You will have to use FTP to move the database file, and set up the
database connection manually. FrontPage cannot work "outside" the
website located in the www folder. In my opinion, your hosts set up is
better than the FrontPage set up described above.