Unanswered: Problems with Access ADP and MSDE SQL Server
I have just migrated our school reporting system from access to an access adp & MSDE SQL server.
We have been having problems with people writing a comment in a text field (in the access ADP from) clicking to go onto the next boy to write a comment, and then when they go back the data has vanished from the previous boy's comments.
Everything worked fine in the access MDB, so we have had to move back to that temporarily. I though it may have something to do with the 5 concurrent something limit on MSDE, but not sure. Would appreciate a lot any comments or ideas any has - THANK YOU!
Some technical data about the DB:
Tables that are accessed by the form&subform:
[DATA] (Has RefNo, Name, class etc.)
[R - MATHS] (Subject tables containing RefNo and comment fields)
[MR - Previous] (Previous Class Marks)
[R - Maths_Pr] (Previous Reports)