473,714 Members | 2,540 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Calling Access 2003 from cmd file via Windows Scheduler

I am trying to call a macro using a command file by using Windows
Scheduler. I am able to run the command file and the macro runs
without issue if I doubleclick on the *.cmd file. When I try
scheduling the job to run via scheduler it appears that Accesss opens(I
can see MSAccess in the task manager window) but the macro is not
invoked. Does anyone have an idea what the issue can be? I am able to
call command files to run pl scripts thru scheduler and to run other
scripts I just am not able to run Access macros. Any help is
appreciated and please let me know if you need any further information.
I am an admin on the box and on the database.

thanks,
Pat

Nov 28 '05 #1
2 2449
It may be that the cmd file is finishing before the macro runs and Access is
being closed. What is the command line you are using in the cmd file?
Couldn't you just have the scheduled program call Access without using the
cmd file?

--
Wayne Morgan
MS Access MVP
"Pat_RI" <PA*****@YAHOO. COM> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
I am trying to call a macro using a command file by using Windows
Scheduler. I am able to run the command file and the macro runs
without issue if I doubleclick on the *.cmd file. When I try
scheduling the job to run via scheduler it appears that Accesss opens(I
can see MSAccess in the task manager window) but the macro is not
invoked. Does anyone have an idea what the issue can be? I am able to
call command files to run pl scripts thru scheduler and to run other
scripts I just am not able to run Access macros. Any help is
appreciated and please let me know if you need any further information.
I am an admin on the box and on the database.

thanks,
Pat

Nov 28 '05 #2
I believe I figured it out I didnt' setup the correct security on the
scheduled task. I use the .cmd file to archive, FTP, and log the files
that are created.

Nov 28 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1548
by: Derek | last post by:
I am writing an ASP.NET application that can add and remove items to the task scheduler. This works fine on Windows XP, but generates an Exception on Windows 2003: System.UnauthorizedAccessException: Access is denied. "ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity" How can I grant the ASPNET local user account permission
11
3760
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue, I am posting this on all of the three newsgroups. That's the setup: Windows 2003 Server with IIS and ASP.NET actiavted Access 2002 mdb file (and yes, proper rights are set on TMP paths and path,
5
6120
by: Joseph | last post by:
Hello, I have a C# program that builds a txt file and then, calls an external exe (this external exe simply imports this txt file into a DBF (DBase) file. (we copy a template of the DBF file into the process folder where the exe lies and then this clipper EXE does the data move from the txt file to the DBF file). This process works fine on at least 3 PCs (Win 2K Pro and Win XP Pro) - irrespective of whether I schedule the process or...
12
18669
by: Phil Powell | last post by:
<cfquery name="getAll" datasource="#request.dsn#"> SELECT U.userID, U.fname, U.lname, U.phone, U.lastLoggedIn, U.choiceId, U.experience, T.label AS teamLabel, R.label AS roleLabel FROM User U LEFT JOIN UserTeamAssoc UTA ON UTA.userID = U.userID, Role R, UserRoleAssoc URA, Team T WHERE U.userID = URA.userID AND URA.roleID = R.roleID AND U.userId > 1
8
3240
by: Mike Thomas | last post by:
I have two clients now who want to have an Access 2000 & 2002 application running on NT Server 2000 do some file updating at night when nobody is in the office. I have used Windows scheduler to schedule the apps to start at 4:00 am, but at that time of night, nobody is logged on to the server. Is it possible to get Access to run on a server when nobody is logged on? Many thaks Mike Thomas
1
2942
by: Mike Thomas | last post by:
I want to start this thread again - on my first attempt I was a little ambiguous and was not able to get the answer I need. I am trying to start Access 2000 on Windows NT 2000 Server by using the scheduler with the command line: "c:\Program Files\Microsoft Office\Office\msaccess.exe" "d:\Apps\ChangeManagement.mdb" /x StartLoad This works when I run it from the "run" box, or via the scheduler when I am
11
6596
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am not logged into the server, Access is not able to print to the printer. The error is pretty...
4
26814
by: CliffKing | last post by:
I am trying to use Windows Task Scheduler to run a batch file for an already open MS Access database. Below is the syntax to the batch file: Batch file: DailySalesExport.bat REM This runs the macro that exports the reports to the J drive PATH = "C:\Program Files\Microsoft Office\Office\;C:\Windows\Command" START /WAIT Msaccess.exe "D:\acesdata\SALES\Daily2005.mdb" /x "SnapShotExportDailySales" EXIT
9
42198
by: Matt | last post by:
How would I do this ... I want to set the Windows Scheduler to run the ..bat file which will open an access database at like 2 in the AM. What code do I need in the .bat file.
0
9307
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9071
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9009
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7946
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6627
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4462
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4715
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3155
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2105
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.