Yup, that was the issue. Once I copied it to documents and manually opened the file all was well. Using the SQLiteDatabaseConnector just died a miserable death because it not using the file I thought it was. Actually opening the file in the IDE showed incorrect data types and running an SQL query kept crashing the IDE.
Doing it the old fashioned way and manually connecting to the database file works a treat.
Things change a lot over the years
. Thanks for the help