search

nuintun / node-adodb

A node.js javascript client implementing the ADODB protocol on windows.
https://nuintun.github.io/node-adodb
MIT License
185 stars 51 forks source link

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' #463

Open frmichetti opened 2 years ago

frmichetti commented 2 years ago

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 commented 2 years ago

Note: the system is open only by one user

dlh2 commented 2 years ago

+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.