I've got a MySQL database that I ported from MS Access using mdbtools and essentially this: http://www.codediesel.com/data/migratin ... -to-mysql/
I've successfully connected base to my new MySQL database. However, some of the tables have issues upon trying to open them.
- The database has 6 tables.
4 of them open fine.
1 of them gives an error of "The data could not be loaded. Zero date value prohibited."
The 6th one does nothing (when trying via OO on Windows 10) , or opens a window with nothing in it that cannot be closed (when trying via LO on Linux Mint).
My question is: How do I go about troubleshooting the issues with the 2 tables that I cannot open?