Best Way to solve this error 'It has already been opened exclusively by another user, or you need permission to view and write the data'

[frmichetti]

I built a backend with node adodb and sometimes I need to run 2 queries at the same time in my database, but sometimes I get the following exception:

'Microsoft Access database engine cannot open or write the file 'file_name'. It has already been opened exclusively by another user, or you need permission to view and write the data.

What is the best way to solve this problem? Is there any configuration to allow multiple access to the database at the same time? Note: Within Access, the database is already configured to allow shared mode.

[frmichetti]

Note: the system is open only by one user

[dlh2]

+1

I thought about changing the way it reads the DB with the connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Mode=Read

Sounds good, doesn't work.