Database Starting Point

[Mary I.]

If this is the wrong ng please direct me to the right one.

I am just starting to think about adding a db to my Webs. I want to use a db
to change pages within various Webs and subwebs by scheduling these pages
ahead of time so the pages will already be loaded (visible) when a visitor
arrives. Sometimes I will need to replace one exisitng page with one or more
pages for the scheduled time period.

After the time period has passed, I want the Web or subweb changed back to
what is was before the original change took place automatically. None of the
Webs or subwebs will require any ecommerce or tranactional capability.

I'm not sure where to start. Will Access do what I need or will something
more complicated be needed? Any advice or suggestions would be greatly
appreciated. I have no idea where to start!

[Jeff Cochran]

Re: Database Starting Point

On Fri, 27 Feb 2004 15:00:07 -0500, "Mary I." <maryi127@aol.c om>
wrote:
[color=blue]
>If this is the wrong ng please direct me to the right one.
>
>I am just starting to think about adding a db to my Webs. I want to use a db
>to change pages within various Webs and subwebs by scheduling these pages
>ahead of time so the pages will already be loaded (visible) when a visitor
>arrives. Sometimes I will need to replace one exisitng page with one or more
>pages for the scheduled time period.[/color]

That's not why you'd want a database serving your web site. You'd
wantt he database so each time the visitor hits your site, current
data is pulled from the database. If you simply want shceduled
changes, what you really want is a scheduled copy.
[color=blue]
>After the time period has passed, I want the Web or subweb changed back to
>what is was before the original change took place automatically. None of the
>Webs or subwebs will require any ecommerce or tranactional capability.
>
>I'm not sure where to start. Will Access do what I need or will something
>more complicated be needed? Any advice or suggestions would be greatly
>appreciated. I have no idea where to start![/color]

Start by creating the original page, then the changed page. Wirte a
batch file to copy firs one to the production site, then the other.
The use the Windows scheduling service to schedule that change
whenever you wish. Not a database, not ASP.

Jeff

[Mary I.]

Re: Database Starting Point

Hi Jeff,

Thanks for your reply but I haven't heard of the Windows scheduling service,
and having no programming background, don't know how to write a batch file.
Would a batch file, once I have correctly set up a schedule for say a week
or a month in advance, allow me to "set and forget" it?

I know in reality I would have to check everything periodically, but is the
concept of a batch file like an airline schedule? If it is, I think setting
up a schedule with a batch file may be what I need.


"Jeff Cochran" <jcochran.nospa m@naplesgov.com > wrote in message
news:40432d83.1 612583041@msnew s.microsoft.com ...[color=blue]
> On Fri, 27 Feb 2004 15:00:07 -0500, "Mary I." <maryi127@aol.c om>
> wrote:
>[color=green]
> >If this is the wrong ng please direct me to the right one.
> >
> >I am just starting to think about adding a db to my Webs. I want to use a[/color][/color]
db[color=blue][color=green]
> >to change pages within various Webs and subwebs by scheduling these pages
> >ahead of time so the pages will already be loaded (visible) when a[/color][/color]
visitor[color=blue][color=green]
> >arrives. Sometimes I will need to replace one exisitng page with one or[/color][/color]
more[color=blue][color=green]
> >pages for the scheduled time period.[/color]
>
> That's not why you'd want a database serving your web site. You'd
> wantt he database so each time the visitor hits your site, current
> data is pulled from the database. If you simply want shceduled
> changes, what you really want is a scheduled copy.
>[color=green]
> >After the time period has passed, I want the Web or subweb changed back[/color][/color]
to[color=blue][color=green]
> >what is was before the original change took place automatically. None of[/color][/color]
the[color=blue][color=green]
> >Webs or subwebs will require any ecommerce or tranactional capability.
> >
> >I'm not sure where to start. Will Access do what I need or will something
> >more complicated be needed? Any advice or suggestions would be greatly
> >appreciated. I have no idea where to start![/color]
>
> Start by creating the original page, then the changed page. Wirte a
> batch file to copy firs one to the production site, then the other.
> The use the Windows scheduling service to schedule that change
> whenever you wish. Not a database, not ASP.
>
> Jeff[/color]

[Jeff Cochran]

Re: Database Starting Point

On Mon, 1 Mar 2004 08:15:49 -0500, "Mary I." <maryi127@aol.c om> wrote:
[color=blue]
>Thanks for your reply but I haven't heard of the Windows scheduling service,
>and having no programming background, don't know how to write a batch file.
>Would a batch file, once I have correctly set up a schedule for say a week
>or a month in advance, allow me to "set and forget" it?[/color]

Sure.
[color=blue]
>I know in reality I would have to check everything periodically, but is the
>concept of a batch file like an airline schedule? If it is, I think setting
>up a schedule with a batch file may be what I need.[/color]

Not really. The batch file is simply a file that contains a set of
commands to be executed. You can copy files, move files, etc. quite
easily. The scheduler service handle the scheduling.

See:

http://www.cknow.com/tutorcom/batch01_intro.htm

http://windows.about.com/library/weekly/aa001022a.htm

You'll want a Windows administration group for help with this, it's
not ASP.

Jeff

[color=blue]
>"Jeff Cochran" <jcochran.nospa m@naplesgov.com > wrote in message
>news:40432d83. 1612583041@msne ws.microsoft.co m...[color=green]
>> On Fri, 27 Feb 2004 15:00:07 -0500, "Mary I." <maryi127@aol.c om>
>> wrote:
>>[color=darkred]
>> >If this is the wrong ng please direct me to the right one.
>> >
>> >I am just starting to think about adding a db to my Webs. I want to use a[/color][/color]
>db[color=green][color=darkred]
>> >to change pages within various Webs and subwebs by scheduling these pages
>> >ahead of time so the pages will already be loaded (visible) when a[/color][/color]
>visitor[color=green][color=darkred]
>> >arrives. Sometimes I will need to replace one exisitng page with one or[/color][/color]
>more[color=green][color=darkred]
>> >pages for the scheduled time period.[/color]
>>
>> That's not why you'd want a database serving your web site. You'd
>> wantt he database so each time the visitor hits your site, current
>> data is pulled from the database. If you simply want shceduled
>> changes, what you really want is a scheduled copy.
>>[color=darkred]
>> >After the time period has passed, I want the Web or subweb changed back[/color][/color]
>to[color=green][color=darkred]
>> >what is was before the original change took place automatically. None of[/color][/color]
>the[color=green][color=darkred]
>> >Webs or subwebs will require any ecommerce or tranactional capability.
>> >
>> >I'm not sure where to start. Will Access do what I need or will something
>> >more complicated be needed? Any advice or suggestions would be greatly
>> >appreciated. I have no idea where to start![/color]
>>
>> Start by creating the original page, then the changed page. Wirte a
>> batch file to copy firs one to the production site, then the other.
>> The use the Windows scheduling service to schedule that change
>> whenever you wish. Not a database, not ASP.
>>
>> Jeff[/color]
>[/color]

[Mary I.]

Re: Database Starting Point

Thanks Jeff,

I have sent an email to the winxp.security_ admin ng.
"Jeff Cochran" <jcochran.nospa m@naplesgov.com > wrote in message
news:4043a0f0.1 642132151@msnew s.microsoft.com ...[color=blue]
> On Mon, 1 Mar 2004 08:15:49 -0500, "Mary I." <maryi127@aol.c om> wrote:
>[color=green]
> >Thanks for your reply but I haven't heard of the Windows scheduling[/color][/color]
service,[color=blue][color=green]
> >and having no programming background, don't know how to write a batch[/color][/color]
file.[color=blue][color=green]
> >Would a batch file, once I have correctly set up a schedule for say a[/color][/color]
week[color=blue][color=green]
> >or a month in advance, allow me to "set and forget" it?[/color]
>
> Sure.
>[color=green]
> >I know in reality I would have to check everything periodically, but is[/color][/color]
the[color=blue][color=green]
> >concept of a batch file like an airline schedule? If it is, I think[/color][/color]
setting[color=blue][color=green]
> >up a schedule with a batch file may be what I need.[/color]
>
> Not really. The batch file is simply a file that contains a set of
> commands to be executed. You can copy files, move files, etc. quite
> easily. The scheduler service handle the scheduling.
>
> See:
>
> http://www.cknow.com/tutorcom/batch01_intro.htm
> http://windows.about.com/library/weekly/aa001022a.htm
>
> You'll want a Windows administration group for help with this, it's
> not ASP.
>
> Jeff
>
>[color=green]
> >"Jeff Cochran" <jcochran.nospa m@naplesgov.com > wrote in message
> >news:40432d83. 1612583041@msne ws.microsoft.co m...[color=darkred]
> >> On Fri, 27 Feb 2004 15:00:07 -0500, "Mary I." <maryi127@aol.c om>
> >> wrote:
> >>
> >> >If this is the wrong ng please direct me to the right one.
> >> >
> >> >I am just starting to think about adding a db to my Webs. I want to[/color][/color][/color]
use a[color=blue][color=green]
> >db[color=darkred]
> >> >to change pages within various Webs and subwebs by scheduling these[/color][/color][/color]
pages[color=blue][color=green][color=darkred]
> >> >ahead of time so the pages will already be loaded (visible) when a[/color]
> >visitor[color=darkred]
> >> >arrives. Sometimes I will need to replace one exisitng page with one[/color][/color][/color]
or[color=blue][color=green]
> >more[color=darkred]
> >> >pages for the scheduled time period.
> >>
> >> That's not why you'd want a database serving your web site. You'd
> >> wantt he database so each time the visitor hits your site, current
> >> data is pulled from the database. If you simply want shceduled
> >> changes, what you really want is a scheduled copy.
> >>
> >> >After the time period has passed, I want the Web or subweb changed[/color][/color][/color]
back[color=blue][color=green]
> >to[color=darkred]
> >> >what is was before the original change took place automatically. None[/color][/color][/color]
of[color=blue][color=green]
> >the[color=darkred]
> >> >Webs or subwebs will require any ecommerce or tranactional capability.
> >> >
> >> >I'm not sure where to start. Will Access do what I need or will[/color][/color][/color]
something[color=blue][color=green][color=darkred]
> >> >more complicated be needed? Any advice or suggestions would be greatly
> >> >appreciated. I have no idea where to start!
> >>
> >> Start by creating the original page, then the changed page. Wirte a
> >> batch file to copy firs one to the production site, then the other.
> >> The use the Windows scheduling service to schedule that change
> >> whenever you wish. Not a database, not ASP.
> >>
> >> Jeff[/color]
> >[/color]
>[/color]