Newbie MSAccess Jetcomp.exe

[[email protected]]

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

[Marcus Tettmar]

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.

[Bob Hansen]

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
.....
.....
.....