CODEWITHSUNDEEP
ms-accesserror-handlingvba
Sinister Beard
Sinister Beard

Reputation: 3680

What's the error number for "'The database engine could not lock table"?

What's the error number for "The database engine could not lock table..." in Access? I have an intermittent fault that it's hard to reproduce (it only occurs when two people open the database at exactly the same time) so I want to build in some error handling, but can't find its error number listed anywhere.

Upvotes: 1

Views: 380

Answers (1)

HansUp
HansUp

Reputation: 97131

Sounds like Error 3211

You can double-check the message template for that error in the Immediate window:

? AccessError(3211)
The database engine could not lock table '|' because it is already in use by another person or process.

Upvotes: 2

Related Questions