Unable to open database containing an invalid table.
A pure Java JDBC driver for Microsoft Access database files
Brought to you by:
jamadei
Menu
▾
▴
I go ta customer database today which contained a table without columns.
That's bad enough as it is and should be fixed of course.
The problem I faced with UCanAccess was, that I could not even open a SQL connection to this DB, it would abort even if I didn't access this table.
When opening a SQL connection, I got this error:
"UCAExc:::5.0.1 needs column or cannot drop sole column of table"
The table in question is called "dbo_ST_SACHBEARBEITER", I removed most of the rest.
The error should only occur when the table is accessed, not when opening the connection.