janerussel
MIS
Hello;
I'm really struggling with this one. I have upsized my Access 03 backend to SQL 2k. My Access 03 front end has a main form with a subform. Records that are in the subform prior to the upsize can be deleted. Any new records that I add to the subform cannot be deleted. I get "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time". (This message is erroneous because I am the only one accessing the database.)
My key field in the main form table is an Int field, and in the sub main form there is the same Int field plus 5 other key fields.
Main form
ID Int 4
SubForm
ID Int 4
CalYear varchar 10
JobTitle varchar 50
DeptCode varchar 5
JobClass varchar 5
DeptLoc int 4
Does anyone have a clue?
I'm really struggling with this one. I have upsized my Access 03 backend to SQL 2k. My Access 03 front end has a main form with a subform. Records that are in the subform prior to the upsize can be deleted. Any new records that I add to the subform cannot be deleted. I get "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time". (This message is erroneous because I am the only one accessing the database.)
My key field in the main form table is an Int field, and in the sub main form there is the same Int field plus 5 other key fields.
Main form
ID Int 4
SubForm
ID Int 4
CalYear varchar 10
JobTitle varchar 50
DeptCode varchar 5
JobClass varchar 5
DeptLoc int 4
Does anyone have a clue?
