I have a front end/back end Access 2007 database, and I am experiencing random loss of data! Maddening!
It isn't data that we're necessarily in the midst of using. We will just go to access a record that we KNEW was there, and may find it gone.
It is a database for training courses. My tables are pretty simple: students, classes, and attendance which says which students attended which classes with additional info about that attendance. This morning, I re-entered a class twice (after it disappeared the first time and second time), and re-attached the students to the course, and then it disappeared again, and took another course with it! Then a totally separate type of course was noticed as being gone.
It seems isolated to the classes disappearing, and therefore with cascading the students which are attached to the classes. I don't believe I'm losing the students from the student table.
The only thing different about this database from my other 2 large databases is that there are photos attached to the class attendance, as we have to have a photo each time they come. So it makes the data file larger with the photos.
Any ideas, suggestions, fixes?
I am wondering if I should take off the 'cascade update/delete' from the table relationships to help prevent data loss (i.e. just the class but not the class attendance) and I would only have to re-enter the class, but that's only a half-fix.
Help!
Jessica