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

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" <(E-Mail Removed)> wrote in message news:45c0b88e@212.67.96.135...
> 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
>

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 ?


"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:45c0b88e@212.67.96.135...
>> 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
>>
>
>

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!" (-;
_____________________________________________


"Brian Royston" <(E-Mail Removed)> wrote in message news:45c1ae5c@212.67.96.135...
| 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 ?
|
|
| "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
| news:(E-Mail Removed)...
| > 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" <(E-Mail Removed)> wrote in message
| > news:45c0b88e@212.67.96.135...
| >> 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
| >>
| >
| >
|
|

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:-)


"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!" (-;
> _____________________________________________
>
>
> "Brian Royston" <(E-Mail Removed)> wrote in message
> news:45c1ae5c@212.67.96.135...
> | 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 ?
> |
> |
> | "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> | news:(E-Mail Removed)...
> | > 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" <(E-Mail Removed)> wrote in message
> | > news:45c0b88e@212.67.96.135...
> | >> 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
> | >>
> | >
> | >
> |
> |
>
>

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
==============================================


"Brian Royston" <(E-Mail Removed)> wrote in message news:45c1ca4e@212.67.96.135...
> 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:-)
>
>
> "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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!" (-;
>> _____________________________________________
>>
>>
>> "Brian Royston" <(E-Mail Removed)> wrote in message news:45c1ae5c@212.67.96.135...
>> | 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 ?
>> |
>> |
>> | "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>> | news:(E-Mail Removed)...
>> | > 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" <(E-Mail Removed)> wrote in message
>> | > news:45c0b88e@212.67.96.135...
>> | >> 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
>> | >>
>> | >
>> | >
>> |
>> |
>>
>>
>
>