scheduled update of database

[vasanth kumar]

Hi,

I am using MS Access as database. I need to update the table on the 1st
day of every quarter. Is there anyway to achieve ASP or MSAccess.

or should I have to make my script as a scheduled job of my OS

Regards,
Vasanth

[Bob Barrows [MVP]]

vasanth kumar wrote:

> Hi,
>
> I am using MS Access as database. I need to update the table on
> the 1st day of every quarter. Is there anyway to achieve ASP or
> MSAccess.
>
> or should I have to make my script as a scheduled job of my OS
>

I vote for the latter. This should not be done with ASP. You can create a
macro in your Access database and use the appropriate command-line switch in
a scheduled job to start Access, open the database and run the macro. Post
to an Access newsgroup for details if you can't figure it out from Access
online help.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[vasanth kumar]

is there anything better than a macro.
antivirus does not let run macros. i don't have permissions to override this
behavior.
"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:eOUJy09dEHA.2908@TK2MSFTNGP10.phx.gbl...

> vasanth kumar wrote:

> > Hi,
> >
> > I am using MS Access as database. I need to update the table on
> > the 1st day of every quarter. Is there anyway to achieve ASP or
> > MSAccess.
> >
> > or should I have to make my script as a scheduled job of my OS
> >

> I vote for the latter. This should not be done with ASP. You can create a
> macro in your Access database and use the appropriate command-line switch

in

> a scheduled job to start Access, open the database and run the macro. Post
> to an Access newsgroup for details if you can't figure it out from Access
> online help.
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

[vasanth kumar]

this command line is opening Access database. i don't want to launch Access
Application. I want it to happen in the background.

-Vasanth
"vasanth kumar" <vasanth.kumar@eds.com> wrote in message
news:eB$uip6eEHA.3476@tk2msftngp13.phx.gbl...

> is there anything better than a macro.
> antivirus does not let run macros. i don't have permissions to override

this

> behavior.
> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
> news:eOUJy09dEHA.2908@TK2MSFTNGP10.phx.gbl...

> > vasanth kumar wrote:

> > > Hi,
> > >
> > > I am using MS Access as database. I need to update the table on
> > > the 1st day of every quarter. Is there anyway to achieve ASP or
> > > MSAccess.
> > >
> > > or should I have to make my script as a scheduled job of my OS
> > >

> > I vote for the latter. This should not be done with ASP. You can create

a

> > macro in your Access database and use the appropriate command-line

switch

> in

> > a scheduled job to start Access, open the database and run the macro.

Post

> > to an Access newsgroup for details if you can't figure it out from

Access

> > online help.
> >
> > Bob Barrows
> >
> > --
> > Microsoft MVP - ASP/ASP.NET
> > Please reply to the newsgroup. This email account is my spam trap so I
> > don't check it very often. If you must reply off-line, then remove the
> > "NO SPAM"
> >
> >

>
>

[Bob Barrows [MVP]]

I don't understand your objection: as a scheduled task on a server, the
execution will be invisible to users, in effect "in the background". Simply
have your macro close Access when it completes. I was not aware of any
antivirus program that would prevent an Access macro from running.

Your alternatives are:
a. Create a VB application that does your update and use the OS scheduler to
launch it.
b. Create a vbs file to do the update and use the OS scheduler to run it.
See [url]http://www.aspfaq.com/show.asp?id=2143[/url]

HTH,
Bob Barrows

vasanth kumar wrote:

> this command line is opening Access database. i don't want to launch
> Access Application. I want it to happen in the background.
>
> -Vasanth
> "vasanth kumar" <vasanth.kumar@eds.com> wrote in message
> news:eB$uip6eEHA.3476@tk2msftngp13.phx.gbl...

>> is there anything better than a macro.
>> antivirus does not let run macros. i don't have permissions to
>> override this behavior.
>> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
>> news:eOUJy09dEHA.2908@TK2MSFTNGP10.phx.gbl...

>>> vasanth kumar wrote:
>>>> Hi,
>>>>
>>>> I am using MS Access as database. I need to update the table on
>>>> the 1st day of every quarter. Is there anyway to achieve ASP or
>>>> MSAccess.
>>>>
>>>> or should I have to make my script as a scheduled job of my OS
>>>>
>>> I vote for the latter. This should not be done with ASP. You can
>>> create a macro in your Access database and use the appropriate
>>> command-line switch in a scheduled job to start Access, open the
>>> database and run the macro. Post to an Access newsgroup for details
>>> if you can't figure it out from Access online help.
>>>
>>> Bob Barrows
>>>
>>> --
>>> Microsoft MVP - ASP/ASP.NET
>>> Please reply to the newsgroup. This email account is my spam trap
>>> so I don't check it very often. If you must reply off-line, then
>>> remove the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"