Results 1 to 1 of 1
Thread: can't drop tables
2010-03-31, 15:38 #1
- Join Date
- Jan 2001
- austin, Texas, USA
- Thanked 0 Times in 0 Posts
I have a routine that imports data into Access, and part of this routine involves creating ad-hoc tables to store the imported info and then run a INSERT INTO on pre-defined master tables. this all works. unfortunately, when i try to do something like
dbs.Execute "DROP TABLE <table name>"Code:
DoCmd.DeleteObject acTable, "<table name>"
I've done this thing before in other dbs and this is the first time i've run across this issue.
Thanks in advance!
Problem solved: I converted the sub to a procedure, and broke the routine for deleting the tables into a separate function. attach code to a button:
Call <function Import>
Call <function delete tables>