Hi,
Brand new to scripting with Macro Scheduler.
I have microsofts Jet Compact utility and need to set up a schedule to compact an access database say from test.mdb to to test1.mdb
I then need to copy test1 and rename it test.mdb overwriting the original file.
I though that I could use the following as a starter but found that the send character does not work and also I dont know the syntax to copy the file and or rename it
ExecuteFile>\\wwisdnsbs1\Users\colinjarvis\Desktop\JETCOMP.exe
Send Character/Text>W:\TITAN\Test.mdb
Press Tab
Press Tab
Send Character/Text>W:TITAN\Test1.mdb
Press Tab
Press Tab
Press Enter
CopyFile>W:\TITAN\Test1.mdb
The jetutility can be foun at
http://support.microsoft.com/kb/295334
Any help would be gratefully appreciated
Kind regards
Colin
Newbie MSAccess Jetcomp.exe
Moderators: Dorian (MJT support), JRL
- Marcus Tettmar
- Site Admin
- Posts: 7391
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
First off - you need a WaitWindowOpen line after the ExecuteFile. Right now there is nothing to tell the script to wait until JETCOMP.EXE is open and ready before the script should continue. Right now the rest of the script is executing before JETCOMP has fully opened.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
- Bob Hansen
- Automation Wizard
- Posts: 2475
- Joined: Tue Sep 24, 2002 3:47 am
- Location: Salem, New Hampshire, US
- Contact:
And after WaitWindowOpen> you should use a SetFocus> and move the cursor to the correct position before using the Send> string. Something like this:
WaitWindowOpen>WindowName*
SetFocus>WindowName*
Tab*n
Send>W:\TITAN\Test.mdb
.....
.....
.....
WaitWindowOpen>WindowName*
SetFocus>WindowName*
Tab*n
Send>W:\TITAN\Test.mdb
.....
.....
.....
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!
Bob
A humble man and PROUD of it!