PC Review


Reply
Thread Tools Rate Thread

Access db - use from subsites

 
 
=?Utf-8?B?Q2hlcnls?=
Guest
Posts: n/a
 
      18th Nov 2004
Using Frontpage 2003, how do I use a Access database store in fpdb folder
from other subsites? I want to use same database for different things... I
thought perhaps subsites for different departments so I can restrict access
using site permissions...
 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      18th Nov 2004
Only possible within FP if you set up a systemDSN. You host must allow you or create the systemDSN
for you, otherwise you have use a separate database for each subsite.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Cheryl" <(E-Mail Removed)> wrote in message
news:7857ECD0-0A96-4C26-8B2B-(E-Mail Removed)...
> Using Frontpage 2003, how do I use a Access database store in fpdb folder
> from other subsites? I want to use same database for different things... I
> thought perhaps subsites for different departments so I can restrict access
> using site permissions...



 
Reply With Quote
 
=?Utf-8?B?Q2hlcnls?=
Guest
Posts: n/a
 
      18th Nov 2004
ok.. ty.. and once again, apologies for previous post... being similar but
was having internet problems...

I created a system dsn on the server. That is fine.. but when I create a new
database connection locally.. to use system dsn.. it can't find one...
However, if I go to my remote web site and create a connection there.. it of
course can see it. So, what am I doing wrong?

"Thomas A. Rowe" wrote:

> Only possible within FP if you set up a systemDSN. You host must allow you or create the systemDSN
> for you, otherwise you have use a separate database for each subsite.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Cheryl" <(E-Mail Removed)> wrote in message
> news:7857ECD0-0A96-4C26-8B2B-(E-Mail Removed)...
> > Using Frontpage 2003, how do I use a Access database store in fpdb folder
> > from other subsites? I want to use same database for different things... I
> > thought perhaps subsites for different departments so I can restrict access
> > using site permissions...

>
>
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      18th Nov 2004
For security, you will not see the SystemDSN name when accessing the site remotely. Create on the
site that you can see the list of SystemDSN, then copy the global.asa file into your local site,
then run tools | site setting | database to verify the connection.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Cheryl" <(E-Mail Removed)> wrote in message
news:547494B2-F121-4954-9B49-(E-Mail Removed)...
> ok.. ty.. and once again, apologies for previous post... being similar but
> was having internet problems...
>
> I created a system dsn on the server. That is fine.. but when I create a new
> database connection locally.. to use system dsn.. it can't find one...
> However, if I go to my remote web site and create a connection there.. it of
> course can see it. So, what am I doing wrong?
>
> "Thomas A. Rowe" wrote:
>
>> Only possible within FP if you set up a systemDSN. You host must allow you or create the
>> systemDSN
>> for you, otherwise you have use a separate database for each subsite.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WEBMASTER Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "Cheryl" <(E-Mail Removed)> wrote in message
>> news:7857ECD0-0A96-4C26-8B2B-(E-Mail Removed)...
>> > Using Frontpage 2003, how do I use a Access database store in fpdb folder
>> > from other subsites? I want to use same database for different things... I
>> > thought perhaps subsites for different departments so I can restrict access
>> > using site permissions...

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Do you use Subsites? If so, why? Anna Ullrich {Microsoft} Microsoft Frontpage 16 3rd Aug 2008 10:19 PM
how can we access data of subsites or interrelate subsite =?Utf-8?B?U2hhcmUgTmVlcmE=?= Microsoft Access Getting Started 1 17th Apr 2007 06:14 AM
Subsites and access =?Utf-8?B?ZmlyZXN0b3JtMTk1NA==?= Microsoft Frontpage 1 12th Aug 2006 12:54 PM
how do i get rid of subsites =?Utf-8?B?bG9uZXN0YXI=?= Microsoft Frontpage 2 14th Oct 2004 03:13 PM
Subsites Mary Microsoft Frontpage 7 14th May 2004 05:37 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:21 PM.