Can't drop a MS Access table
I've set up a connection to a Microsoft Access database and can fully access it.
However, if I try to drop a table I get this error:
SQL Error: [Microsoft][ODBC Microsoft Access Driver] The database engine could not lock table 'acct' because it is already in use by another person or process.
Can someone enlighten me as to what I'm doing wrong? I can insert, delete records and even create tables. But I can't drop them.