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