#### interesting way to schedule MS Access jobs

Hi everyone,

I ran across some neat software to schedule MS Access database tasks
to run any time of the day.  Also, it doesn't rely on Windows
Scheduled Tasks, so that is good.  It uses it's own scheduling engine,
check it out:  http://macros.subpacket.com

Cheers,

Chris


 0
cburnacc
5/11/2007 8:54:03 PM
access 16762 articles. 2 followers.

5 Replies
489 Views

Similar Articles

[PageSpeed] 33

Hi Chris

The standard guarantee is something like this

We're so confident that macro scheduler will save you time and money by
running tedious macro tasks late at night that if you are having any problems
whatsoever, we will REFUND YOUR MONEY

We're so confident that macro scheduler will save you time and money by
running tedious macro tasks late at night that if you are having any problems

What does that mean.  If it doesn’t work ???

Can't where they get that windows scheduler is a security risk - I use it on
many DB's.  It will turn on access - run whatever - then turn off access (at
anytime of day or night - as the server is always on, like in most companies)

Not saying not to get your suggestion but not convinced at the moment.
Windows already gives everything this does – and it’s (sort of) free.

--
Wayne
Manchester, England.

"cburnacc" wrote:

> Hi everyone,
>
> I ran across some neat software to schedule MS Access database tasks
> to run any time of the day.  Also, it doesn't rely on Windows
> Scheduled Tasks, so that is good.  It uses it's own scheduling engine,
> check it out:  http://macros.subpacket.com
>
> Cheers,
>
> Chris
>
>

 0
Utf
5/11/2007 9:16:00 PM
cburnacc <cburnacc@gmail.com> wrote:

>I ran across some neat software to schedule MS Access database tasks
>to run any time of the day.  Also, it doesn't rely on Windows
>Scheduled Tasks, so that is good.  It uses it's own scheduling engine,
>check it out:  http://macros.subpacket.com

ran across some neat software" false.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 0
Tony
5/11/2007 10:33:50 PM
Wayne-I-M <WayneIM@discussions.microsoft.com> wrote:

>Can't where they get that windows scheduler is a security risk - I use it on
>many DB's.

And they is the original poster.   I'd suggest asking him directly.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 0
Tony
5/11/2007 10:34:29 PM
SQL Server has something 100 times easier; it is called SQL Agent

any Access Developer worth his BEANS uses Access Data Projects; so we

On May 11, 1:54 pm, cburnacc <cburn...@gmail.com> wrote:
> Hi everyone,
>
> I ran across some neat software to schedule MS Access database tasks
> to run any time of the day.  Also, it doesn't rely on Windows
> Scheduled Tasks, so that is good.  It uses it's own scheduling engine,
> check it out:  http://macros.subpacket.com
>
> Cheers,
>
> Chris


 0
IRS
5/12/2007 12:10:01 AM
Hi Tony

Don't worry the internet is great for letting everyone know if you have
something to sell.

I personally have some cakes that I don't really like so I will be posting a
new website regarding these and offering them for sale.  Not really sure if
there is that much of a market for second hand cakes though.  Worth a try.

Looking for a forum concerning cakes (and how long they last) to post this
too.

--
Wayne
Manchester, England.

"Tony Toews [MVP]" wrote:

> cburnacc <cburnacc@gmail.com> wrote:
>
> >I ran across some neat software to schedule MS Access database tasks
> >to run any time of the day.  Also, it doesn't rely on Windows
> >Scheduled Tasks, so that is good.  It uses it's own scheduling engine,
> >check it out:  http://macros.subpacket.com
>
> ran across some neat software" false.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
>    Please respond only in the newsgroups so that others can
>    Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
>    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>

 0
Utf
5/12/2007 9:54:00 AM

Similar Artilces:

Basic way to make basic databases work on Access2007?
I tried the Microsoft info on this questions and it was really worthless. Let's say a "little guy" makes some unsplit Access 2003 databases with Macros and code which a friend wants to run on Access 2007 without "security" related hassles, including without wanting to have to click through warnings every time it is opened. Is there a simple way to do this? Thanks in advance Sincerely, Fred Fred If you trust your friend, you can tell Access/Windows to trust the location in which the file runs. -- Regards Jeff Boyce Microso...

I am really new to the SQL world, so please bare with me. I have an Access dbs that works fine - it allows me to populate tables from forms. there are several forms, queries and tables Everything works fine until I upsize. Once the upsize is complete, I can open and enter data into the form - but the data does not save back to the tables. What am I missing ? I have checked permission and everything appears to be fine? It works in Access 2003 but not the SQL version. Do you have primary keys defined for all of your tables? If you do, then do you get any error messages? -- Doug Steele,...

Is there a way to speed up Calculation !!!!!!!!!!!!!!!
I have this line of code in my macro: Wks.Range("G3:GA732").Calculate This line of code takes over an hour to execute. The range is all SUMPRODUCT formulae and I have to run the report daily. It takes about 2 hours to run the report. 90% of that is spent executing the "Calculate" code above. What I need to know is this, is there a way to speed-up the Calculating operation or am I stuck with this? Thanks physical limitations get more memory and/or faster cpu -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your...

How do I calculate interest?
I want to create a spreadsheet that shows my kids the power of compounded interest. I want to show them what regular deposits against a specific monthly interest rate results in, at the end of the year. I want to have the interest rate in cell A1 and starting in row 5, in column A I have the date of deposit and in column B I have the deposited amount. Then I want to have a total that calculates the updated balance including the compounded interest rate each month. Any suggestions? TIA! Robert "darkwing_duck" <rbrown999@gmail.com> wrote: > I want to show them...

MS Giving VC++ 2003 Away Free?
http://msdn.microsoft.com/visualc/vctoolkit2003/ Anyone know what VC++ 2003 is ? Or how to extract InstallShield installations without installing? I don't want to corrupt my machine with free software. ;-) -- Jim Carlock I didn't create this, I just think it's funny... http://www.bushorchimp.com/ Post replies to the newsgroup. Your questions are answered at the link you provided. http://msdn.microsoft.com/visualc/vctoolkit2003/ ndy Mortimer [MS] Please do not send email directly to this alias. This alias is for newsgroup purposes only This posting is provided "AS IS...

Hi group, There is a way to schedule a import task, in order to import Invoices? Like the "Systems jobs" Regards, ...

Performance CDF and MS CRM?
Hi All, I am about to try out the MS CRM CDF tool and am looking at loading about 829,626 records into the contact & lead tables -> not sure what the exact split will be yet and about 256,787 records into the company table. How long will it take to run all this through the CDF tool and get this loaded into MS CRM and then how is the performance of MS CRM with this amount of data in it? I'll also be loading maybe another 100,000 records at a later date. Can I use the CDF again for this import even though I'll have a lot of exsting data I want left alone. Thanks, Jerry R...

Is there a way to eliminate specific cells from formulas?
I am creating a table showing daily and weekly averages of Production lines. I want to create a weekly chart but I dont want the weekly totals to include the daily sum and averages. Is there a way to eliminate those cells from the weekly totals? Check the SUBTOTAL function. It ignores other SUBTOTAL functions in its formula range. 1st argument options: Func_Num Function 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Valerian" wrote: > I am creating a table showing da...

Correct way to delete/stop ...\out\Archive
I seem to recall this has been discussed, but I can't find the discussion. I see a bunch of files in my C:\exchsrvr\imcdata\out\Archive and C:\exchsrvr\imcdata\in\Archive . Seems to me that I should be able to delete them. Is there any advantage to keeping them? Is it OK to delete them? If it's OK, what's the correct/safe procedure? -- Regards, Hank Arnold Hank, You can delete them without any problem. They're used for diagnostic purposes and aren't required by your Exchange server. In fact, by default Message Archival is not enabled. If you want to tur...

INTERNET MILLION DOLLARS
INTERNET MILLION DOLLARS - www.InternetMillionDollars.biz Watch the VIDEO on YOUTUBE... NOW! http://www.youtube.com/watch?v=dXQUjk5EGV0 MAKE MONEY INSTANTLY using 2007 featured INTERNET MILLION DOLLARS as a resource. WORK FROM HOME HOMEBASED JOBS AND IDEAS BUSINESS OPPORTUNITY Professor James Bradley's "Quick and real way to make BIG MONEY on the Internet!" The Independent Finally you have FOUND IT! Make a FORTUNE each month... .... every month! 100% ON AUTOPILOT Read it NOW and CHANGE YOUR LIFE! Are you fed up with being short of MONEY all the time? Do you DREAM about a...

How to access different glyphs in MS Word?
How do we access different glyphs of opentype fonts in MS word. The method of opening character map is very cumbersome. Is there any shortcut key or menu button or any other similar such method which can enable typing different glyphs of any character. See http://sbarnhill.mvps.org/WordFAQs/InsertSpecChars.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. S N wrote: > How do we access different glyphs of opentype fonts in MS word. > The me...

pull data from an Access database into Excel template
Is there a way to fill the cells in a report set up in Excel from data in an Access table? I don't want to create a new Excel file, but just populate the cells with Access data. Thanks, Hi You can read data from Access into table on worksheet through an ODBC query. Now create your report using queried data (through links) as source. -- (Don't use my reply address - it's spam-trap) Arvi Laanemets "Randal" <rlwnr@hotmail.com> wrote in message news:#nd$PP9#DHA.2512@TK2MSFTNGP11.phx.gbl... > Is there a way to fill the cells in a report set up in Excel from... No-Interest, No-Payments I apologize if this is a duplicate message, but this message didn't seem to post from my office. I've been fighting with this all weekend, and I can't find a solution. Is it possible to track individual purchases in Money 2003 that have a no-interest with or without payment options? For example, Home Depot has a special offer where any purchases totaling$299 or more using the Home Depot credit card is interest/payment free for 6 months from the date of purchase. I have made two such purchases (one in March, and one in June), but I can't seem to track them individu...

Inserting an Excel Worksheet into an Access form
I'm working on a project that records various metrics and displays them in a crosstab type format (date/year as column headings and metric, business unit as rows). I'd like to insert an excel worksheet in the access form to display the results of the crosstab query. So far I haven't been able to make this work. I inserted the Excel sheet as an object and set the row source type to table/query. I then pointed the row source to the appropriate query. Thus far I am only able to populate the A1 cell, nothing more. Am I missing something or is there a good reference ...

Interest
Greetings! How should I update the interest owed on a student loan. The interest that Money has calculated is completely off b/c I just now put the loan into Money, but have actually had the loan for quite some time. Should I do an account adjustment? If I do this, will Money think I am changing the principal? I'd appreciate any help concerning this matter! Uchenna ...

Hello I am trying to access a https:// site. In Safari it always gives me a certificate error but I can still get to it. I cannot access it at all from IE 8 and wonder why that might be. What settings do I need to check, please? Thanks. Steve "SteveH" <SteveH@discussions.microsoft.com> wrote in message news:73B6AF28-5A6E-4C4B-8EEF-F022D871F859@microsoft.com... > Hello > > I am trying to access a https:// site. In Safari it always gives me a > certificate error but I can still get to it. > > I cannot access it at all from IE 8 and wo...

send an email in a scheduled time
if i want to send an email in certain time, is it possible? For example, can I schedule to send an email at 12pm at night. Of course, I don't want to physically click send for that email, but I want it automatically being sent at scheduled time. please advise. thanks Take a look here, it may help: http://www.slipstick.com/dev/olforms/skedrpt.htm --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google...

Change from a 2-way to a 3 way splitter wnd
Hello, in my application I have a 2 way splitter window. In the left window a tool bar is displayed. Depending on the toolbar button I want to change the layout to a 3 way splitter or from a 3- to a 2 way splitter. I attach a splitter to the MainFrame in CreateClient() with CreateStatic() but I'm not able to put a nested splitter at runtime. Anybody knows, how to change the splitter layout dynamically? Thanks in advance, Torsten. tfa613 wrote: > Hello, > > in my application I have a 2 way splitter window. In the left window a > tool bar is displayed. > Depending on the ...

Watch the critical pack which comes from MS Corp.
--nburilqinp Content-Type: multipart/related; boundary="kpxeviiup"; type="multipart/alternative" --kpxeviiup Content-Type: multipart/alternative; boundary="mzshzikjtmoenyc" --mzshzikjtmoenyc Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to mai...

Is that any way to customize the CRM 3.0 Sales Pipeline Report?
Want to add the 'Company Name' on the Sales Pipeline Report. Hi CEO, yes - it is possible to modify the report using Visual Studio's add-in for the SRS reports. To modify the reports, please download the Sales Pipeline report and Sales Pipeline Detail report (this one shows up in the "Hidden Reports" view) from the Reports section and add extra data to the reports. Hope this helps. -- Manisha Powar (Madhusudanan) Program Manager Microsoft Dynamics - CRM This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for y...