This is a bit embarrassing but here goes...
Sometime ago I went through the pain of creating a 'split' database on my 'work' computer. Everything worked brilliantly until last week when I tried to create a report. Base crashed and even though I tried to do the 'recovery' thing, I now have a weird problem. When I try and access the table of one of the databases I created earlier, I get this error...
The connection to the database source "2013 GTT Learners.file" could not be established
error in script file line: 65 java.io.EOFException in statement [SET TABLE PUBLIC."Students_in_courses" INDEX '9997 9645 9502 0 0 0 109']
The really embarrassing thing is that I can't locate the datasource on my computer. I teach at school and they have a weird system for backing up teacher work. To cut a long story short, I can't find the folder where the datasource might be (and have no idea where to look). The data is being saved somewhere - only I have no idea where this is and am feeling really stupid.
When the problem first occurred, I did a system restore and this fixed it - but the problem has come back and I'm looking for a more permanent fix. To further complicate matters, a different database (on the same machine) works fine.
I've tried 'unzipping' the file in an attempt to be able to access / edit the script file but this did not work (it let me see the xhtml for the tables / queries I'd written, but the actual data is no-where to be found). I've made a brief screencast showing the issue. If you have time / inclination you can see it below.
http://youtu.be/tK-7oePM-kE
Thanks in advance for any suggestions
Dzeni