Delete whole table with SQL and ADO

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I access a table in Access 2007 from ArcGIS using ADO and SQL. I would
like to add some code in my form in GIS that reconciles the backup database
from my laptop.
Can anyone give me an Idea of the SQL to "Drop" the existing backup table
then Make a new backup with the existing, renaming (to include the date).
any help is greatly appreciated.
 
I read about the "Drop" table, but Its how to incorporate it with ADO. All
I've ever done is ...rst.open "select...." Then manipulate the data. Since
I'm not dealing with a record set I'm not sure how to introduce the Drop
table command.
 
Back
Top