Delete whole table with SQL and ADO

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.
 
K

Ken

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check SQL please 2
Append data / Prevent duplicates 4
query links to SQL server and mdb table 1
SQL syntax error with vba 3
can this be use in SQL? 1
date range criteria for SQL server link table 5
Access 2010 append query to SQL is very slow 0
Update access table to sql table 1

Top