S
Stapes
Hi
Something that was working fine has suddenly started chucking out this
error message: -
3211 The database engine could not lock table TM_InvoiceItemGroup
because it is already in use by another person or process.
This is rubbish, as I am the only person working on it.
This is the place where it is failing: -
STRSQL = "SELECT FM_InvoiceImport.Field3, '0' AS Expr1 INTO
TM_InvoiceItemGroup " & _
"FROM FM_InvoiceImport " & _
"GROUP BY FM_InvoiceImport.Field3, '0';"
DoCmd.RunSQL STRSQL
I have tried rebooting my PC. It made no difference.
Any ideas?
Stapes
Something that was working fine has suddenly started chucking out this
error message: -
3211 The database engine could not lock table TM_InvoiceItemGroup
because it is already in use by another person or process.
This is rubbish, as I am the only person working on it.
This is the place where it is failing: -
STRSQL = "SELECT FM_InvoiceImport.Field3, '0' AS Expr1 INTO
TM_InvoiceItemGroup " & _
"FROM FM_InvoiceImport " & _
"GROUP BY FM_InvoiceImport.Field3, '0';"
DoCmd.RunSQL STRSQL
I have tried rebooting my PC. It made no difference.
Any ideas?
Stapes