Why do I receive an error message when I try to change the table in a database using Database Toolbox?

 [Microsoft][ODBC Microsoft Access Driver] The database engine could not lock table 'Consumer' because it is already in use by another person or process.

Answer 1

[MathWorks Support Team]

This bug has been fixed for Release 14 (R14). For previous releases, please read below for any possible workarounds:

When modifying the table of a database or adding a new table to the database, make sure that the database is not open for editing. If the database is open for editing and you try to modify the structure of the database, you will get the above mentioned error.

If it is shared database, make sure that no user has logged into the database to modify it while you are trying to modify it.