[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

Schedule Task 98???????

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
Beeby
Asked:
Beeby
  • 2
1 Solution
 
padrino102298Commented:
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
 
BeebyAuthor Commented:
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
 
linschotenCommented:
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
 
BeebyAuthor Commented:
How do you obtain the exact syntax for the UNC names ie, \\servername\Ddrivesharename?????????
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now