Database from Subweb

[Brian Royston]

Hi All

I am very new to web design although I do know my way around a PC.

I have been asked to create a website for my daughters horse riding club and
have managed to get it to talk to and read from my database. What I would
like to do is read and write to the same database from a secure subweb. Its
location is in _fpdb on the root of my web?

I would also like to know if it is possible to setup a MS Access database on
the Sharepoint Administrator so that I don't have to be live to create and
test my ASP pages?

Thanks in advance

 

[Thomas A. Rowe]

The database needs to be imported into the subweb, where FP will prompt you to create the connect
and then create and place the database into the subweb's fpdb folder.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Brian Royston]

Thanks for that, I am also assuming that I will need to make another
connection to the database in my subweb via the ODBC and create a connection
on my webserver i.e
C:/blah/blah/etc/rootweb/subweb/fpdb/mysubwebdatabase.mdb ?

 

[Stefan B Rusynko]

If you import the mdb into the subweb (and accept the fpdb folder as the location) FP should create it for you (see the global.asa
created in the subweb)

--

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


| Thanks for that, I am also assuming that I will need to make another
| connection to the database in my subweb via the ODBC and create a connection
| on my webserver i.e
| C:/blah/blah/etc/rootweb/subweb/fpdb/mysubwebdatabase.mdb ?
|
|
| | > The database needs to be imported into the subweb, where FP will prompt
| > you to create the connect and then create and place the database into the
| > subweb's fpdb folder.
| >
| > --
| > ==============================================
| > Thomas A. Rowe
| > Microsoft MVP - FrontPage
| >
| > http://www.Ecom-Data.com
| > ==============================================
| >
| >
| > | >> Hi All
| >>
| >> I am very new to web design although I do know my way around a PC.
| >>
| >> I have been asked to create a website for my daughters horse riding club
| >> and have managed to get it to talk to and read from my database. What I
| >> would like to do is read and write to the same database from a secure
| >> subweb. Its location is in _fpdb on the root of my web?
| >>
| >> I would also like to know if it is possible to setup a MS Access database
| >> on the Sharepoint Administrator so that I don't have to be live to create
| >> and test my ASP pages?
| >>
| >> Thanks in advance
| >>
| >
| >
|
|

 

[Brian Royston]

Yep I understand that but will I not need to create another ODBC connection
from within administrative Tools via my control panel on PC and then create
a connection to that from my control panel on my web server?

Apologies if I am been dense but still finding my way around using database
on the web

 

[Thomas A. Rowe]

No, as FP will create the connection for you as long as you import the database into the current
open FP subweb / subsite.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

Yep I understand that but will I not need to create another ODBC connection from within
administrative Tools via my control panel on PC and then create a connection to that from my
control panel on my web server?

Apologies if I am been dense but still finding my way around using database on the web

If you import the mdb into the subweb (and accept the fpdb folder as the location) FP should
create it for you (see the global.asa
created in the subweb)

--

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


| Thanks for that, I am also assuming that I will need to make another
| connection to the database in my subweb via the ODBC and create a connection
| on my webserver i.e
| C:/blah/blah/etc/rootweb/subweb/fpdb/mysubwebdatabase.mdb ?
|
|
| | > The database needs to be imported into the subweb, where FP will prompt
| > you to create the connect and then create and place the database into the
| > subweb's fpdb folder.
| >
| > --
| > ==============================================
| > Thomas A. Rowe
| > Microsoft MVP - FrontPage
| >
| > http://www.Ecom-Data.com
| > ==============================================
| >
| >
| > | >> Hi All
| >>
| >> I am very new to web design although I do know my way around a PC.
| >>
| >> I have been asked to create a website for my daughters horse riding club
| >> and have managed to get it to talk to and read from my database. What I
| >> would like to do is read and write to the same database from a secure
| >> subweb. Its location is in _fpdb on the root of my web?
| >>
| >> I would also like to know if it is possible to setup a MS Access database
| >> on the Sharepoint Administrator so that I don't have to be live to create
| >> and test my ASP pages?
| >>
| >> Thanks in advance
| >>
| >
| >
|
|