J:\QC-App 1.0.mdb" in the text file should work...
If not, try opening up a command prompt and entering the command that would be run in the batch script, so...
START "" "%PROGRAMFILES%\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE" %1 /COMPACT /REPAIR
would become
START "" "C:\Program Files\MICROSOFT...
If your printer is connected to your parallel port, simply send the data to port LPT1. I'm not very competent with VBA, but in a batch script this would look something like:
ECHO The data is as follows: %DataStoredInThisVariable%>>LPT1
yes - instead of using
START "" "%PROGRAMFILES%\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE" %1 /COMPACT /REPAIR
use something like this:
CALL "%PROGRAMFILES%\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE" %1 /COMPACT /REPAIR
IF NOT %ERRORLEVEL%==0 GOTO FAIL
ECHO Compact and Repair on %DATE% at %TIME% was...
Thanks for responding LloydSev.
There is a pdb on the palm scanners named DefConnection2db_EnUS.pdb that contains the Connection Setup options, so was really hoping that the primary PC would be stored somewhere in a similar way.
Another possible way to do it though - any idea if i can set up...
We have roughly 30 symbol spt 1700 and 1742 units that sync to one of our servers remotely from several uk sites, as well as various sites across europe. However, we now want to migrate all these units to a new server.
I wrote a quick batch file that syncs that palm data (c:\program...
Acc2k is in fact simpler as it doesnt give the irritating "Successfully repaired [yourdb.mdb]" dialogue, so you can strip out the reference to the clickok.ahk script from the batch script and you wont need to install AutoHotKey. the path to the access program is also slightly different - change...
We have several ac97 db's that require compacting and repairing frequently, and also need to have macro's run inside them. i wrote the following batch script to do it all for us. you then just add the script to your windows scheduled tasks.
put the full unc paths to all your ac97 db's in a text...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.