Alexander Lamb wrote:
Well, I even tried to insert a row in the table. The table contains
the data. The file on the disk is 2K length. The PRAGMA commands tells
me I am in legacy file format mode (1).... but when I quit then
return, I am back to 0!
I just tried the same thing and got the same result.
It is possible that the only problem is that the pragma is not returning
the expected result, but is in fact changing the file format when used
as directed.
Have you tried copying the file to your Mac to see whether it can be read?
Gerry, admittedly grasping at straws