MS Access and TD locking problems
We are running TD 6.02 and MS Access 2000 and have an issue where rows within the "test" table are becoming corrupt and needing to have a "repair" done using the DBAdmin tool.
Anyone know why this happens?
The error message shown in Access when I open the particular table and put my cursor over the cell in question is:
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time"
I don't think that 2 people were trying to change the same test script at the time.
How hard is it to upgrade to SQL Server 2000 and will this solve this particular problem?