Creating reports and dashboards | Stimulsoft community forum

Hi all,

In one of my reports I need to connect to an Access DB.
Here is my connection string: It works very well, except when the DB is already opened through Access by somebody else.
Is there an additional parameter I can add to the connection string to bypass this access issue? I just want to have access to the data in read only mode to print some labels. I tried by adding: to the connection string, but it says "Impossible to lock the DB".

Thanks for your help.

Hello.

We couldn't reproduce your issue.
What version do you use?
Please, send us step-by-step instruction how to reproduce the issue.

Thank you.

Thanks for your reply.
I'll try to explain better.
Stimulsoft is on a server on our network, here is the version information: The DB (built on Access 2007) is on my local computer.

When the DB is not opened, I can successfully test the connection string: Now I just open the DB with MS Access.
Then if I try again to test the connection string, I get an error message that the DB is already in use: Same error if I add to the connection string, just before the "Persist security...".

Hope this helps.
Thank you.

Hello,

We couldn't reproduce your issue.
Can you please send us a test database on which reproduces the issue for analysis.

Thank you.

I could not reproduce it neither when I try to make an example for you!
So I'm thinking maybe the person opens the DB in exclusive mode, which would cause my connection to fail.
Could it be because of this?

Thanks.

Hello.

It seems that the problem is in the file sharing in your network.
Please, check if your database file acceptable for several connections.

Thank you.