.mdb file + :odbc + drop-index => belly up

After creating an index with:
  (create-index [cftypeid] :on [cellfeature] :attributes '([typeid]))
either
  (drop-index [cftypeid] :on [cellfeature])
or
  (drop-index [cftypeid])
will drop me into the debugger:

  A database error occurred: NIL / 42000
  [Microsoft][ODBC Microsoft Access Driver] Syntax error in DROP TABLE or
DROP INDEX.
  [Condition of type SQL-DATABASE-ERROR]

  Restarts:
  0: [RETRY] Retry SLIME REPL evaluation request.
  1: [ABORT] Return to SLIME's top level.
  2: [ABORT] Abort
  3: [CLOSE-CONNECTION] Close SLIME connection
  4: [ABORT] Exit debugger, returning to top level.

  Backtrace:
  0: (ODBC:%SQL-EXEC-DIRECT ..)
  1: ((SB-PCL::FAST-METHOD ODBC-DBI::%DB-EXECUTE (ODBC-DBI::ODBC-QUERY T))
#(0 NIL) #<unavailable argument> #<ODBC-DBI::ODBC-QUERY {24FBBEE9}> "DROP
INDEX CFTYPEID")[:EXTERNAL]
  2: (ODBC-DBI::DB-QUERY #<ODBC-DBI::ODBC-DB {24B1C649}> "DROP INDEX
CFTYPEID")[:EXTERNAL]
  3: (ODBC-DBI:SQL "DROP INDEX CFTYPEID")[:EXTERNAL]
  4: ((SB-PCL::FAST-METHOD CLSQL-SYS:DATABASE-EXECUTE-COMMAND (T
CLSQL-SYS:GENERIC-ODBC-DATABASE)) ..)
  5: ((LAMBDA (SB-PCL::.PV. SB-PCL::.NEXT-METHOD-CALL. SB-PCL::.ARG0.
SB-PCL::.ARG1.)) ..)
  6: ((SB-PCL::FAST-METHOD EXECUTE-COMMAND (STRING)) #<unavailable argument>
#<unavailable argument> "DROP INDEX CFTYPEID")[:EXTERNAL]
  7: (SB-INT:SIMPLE-EVAL-IN-LEXENV (DROP-INDEX
#<CLSQL-SYS:SQL-IDENT-ATTRIBUTE CFTYPEID>) #<NULL-LEXENV>)

More background info:
  1. CLSQL 4.3.0
  2. SBCL 1.0.33.4 win32
  3. Using :ODBC database type to clsql:connect to a .mdb file.

Best,

Jason

_______________________________________________
CLSQL mailing list
[email protected]
http://lists.b9.com/cgi-bin/mailman/listinfo/clsql