I have been unable to find away to do this with an Access Macro, so now am trying
to achieve the same results within CF.
I run a macro within Access that Deletes a table and then runs a Make Table Query.
My problem is if I have a problem the table gets deleted and the next time the macro
runs and errors out as it has no table to delete. If I knew up front whether the table
exists I wouldn't try and delete it, just create the new one,
If I could do this within Access it would be easier.
If I could do this from CF I could achieve the same results as well.
Sure would appreciate some suggestions here.
BTW The reason for all this is MAS90's Providex driver will not allow me to
access their tables in either a linked table in Access or directly via ODBC.
Do I create a link in Access and on a schedule I run a batch file that opens
Access from the command line and runs the macro that deletes, and then does
a make table from the linked table. Then it compresses the database to help
keep the database size manageable.
This works flawlessly 98 per cent of the time for the past year or so. I want to
cover my butt for the remaining 2 per cent.
Terry Troxel
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
