Solved

Schedule Task 98???????

Posted on 1998-10-22
4
177 Views
Last Modified: 2013-12-28
I wish to run a task which will compact my Access database overnight, it works on one PC running windows 95 but the same task will not execute on 98?  The run line reads C:\PROGRA~1\MICROS~1\OFFICE\MSACCESS.EXE D:\Data97.mdb /compact" Now I did want this task to work across the network and activate the drive on the sever, but for now I would be happy to see it work on my local drive.  I set the time and date and whenthe clock reaches that time ....nothing and the schedule then sets the next run time to the following day as it is a daily task.  Can anyone help????? Its beyond me is there any test I could run to see if schedule is working correctly ???????
0
Comment
Question by:Beeby
  • 2
4 Comments
 

Expert Comment

by:padrino102298
ID: 1646568
The problem is with the command line switches in the run line for access.. It needs to read like this..

"C:\PROGRA~1\MICROS~1\OFFICE\MSACCESS.EXE" D:\Data97.mdb /compact

You need the executable itself in the quotes and any parameters on the outside.. It will run properly if setup like this
0
 

Author Comment

by:Beeby
ID: 1646569
I must reject your answer because it works without the quote marks.  It works on the local drive, it's when I try to access the drive on the server.  The server inquestion contains little security restrictions once in Windows you are able to access the drive.  So does it require different different coding to access this drive????????  C:\PROGRA~1\MICROS~1\OFFICE\MSACCESS.EXE G:\Data97.mdb /compact is what I am using what must I change?????? I have tried the quote marks and it still does not work.  Thank you
0
 
LVL 3

Accepted Solution

by:
linschoten earned 50 total points
ID: 1646570
Instead of using drive names...use UNC names ie, \\servername\Ddrivesharename\data97.mdb /compact
The quotes are mainly need for longfilenames.
ie C:\PROGRA~1\MICROS~1\OFFICE\MSACCESS.EXE
or "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE"

Your command line should work.The thing to look at would be if the directory structure is correct. The C:\PROGRA~1 could be :\PROGRA~2\ for example.
Run you command from a Dos Window and see if it works.
0
 

Author Comment

by:Beeby
ID: 1646571
How do you obtain the exact syntax for the UNC names ie, \\servername\Ddrivesharename?????????
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now