Error 3008 able is already in use exclusively by another user (1 Viewer)

[JSqueaky]

MS ACCESS 2019 Error Message : The table is already in use exclusively by another user or it is already open thru the user interface & can't be manipulated programmatically.
That doesn't make sense. I am a single user and not attached to a network and get this message often.

 

[theDBguy]

Hi. Welcome to the forum. It doesn’t make sense until you remember Access considers all connections to a data source as a “user.” So, even if you’re the only using the database, but if you were to open a form bound to a table and then execute code to open the same table at the same time, Access will say there are two users connected to the same table. And if one of those “users” tries to make any change that conflicts with the changes made by the other one, then Access will probably throw an error.

 

[The_Doc_Man]

To take theDBguy's comments a little further, this can sometimes be that the form is bound to a table AND a control is bound to the same table AND the properties for each case are NOT set to Optimistic Locks or No Locks. There ARE other reasons, but that one is a good place to start.