What's up all? Quick question for anyone out there... I have a java app that I created that basically create a temporary table, in Access 97, does some manipulations, and then drops the table. This code works fine in VB. However, when I convert it over to Java, I keep getting an error at the end of the logic. This is the error
This is happening when I attempt to drop the table. I am using a recordset that references the table right before I drop it, but I am closing the recordset before I call the DROP statement. Any ideas on what could be wrong? Thanks in advance...
Doug
Code:
ERROR executing [Microsoft][ODBC Microsoft Access Driver] The database engine could not lock table 'tmpDuplicateFunds' because it is already in use by another person or process.
This is happening when I attempt to drop the table. I am using a recordset that references the table right before I drop it, but I am closing the recordset before I call the DROP statement. Any ideas on what could be wrong? Thanks in advance...
Doug