I have been sucessfully running batch files from the server
task manager that opens access from the command line and
runs a macro, then when that exits it runs another command
that opens access and compacts the database I just ran the
first macro on.
Now all this has worked perfectly for a couple years now and
the reason for all this is I could not get CF to read the
database tables directly through the Providex ODBC drivers
supplied with Mas90. I run these batch files which delete
tables and then run a make table query which CF does read,
and then do the compact to help MS do their housekeeping. As
soon as that is done I run a CF task that does all the CF
goodies I need.
Now here is the reason for this long-winded post:
I do not know how to use any logic in either my batch
calling Access or the macro in Access to act differently if
there is no table to delete when the macro runs and trys to
delete the table prior to doing the make table query.
Here is an example of one of the batch files:
------------------------------------------------------
d:
cd\program files\microsoft office\office
msaccess d:\inetpub\databases\SOMASTER.mdb /x updateSO
msaccess d:\inetpub\databases\SOMASTER.mdb /compact
exit
------------------------------------------------------
Here's the printout of the macro in Access:
------------------------------------------------------
Actions
Name Condition Action Argument
Value
DeleteObject Object Type: Table
Object Name: SO1
OpenQuery Query Name: makeSO1
View: Datasheet
Data Mode: Edit
------------------------------------------------------
The only time this happens is when our friends from MS do a
security update and something in my tasks gets out of
sequence.
I really would like to hear from any of you who have run
into anything like this in your travels.
Terry
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271400
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
