I have problem to connect crystal report with MSaccess 2007-2013

[honest]

Hi
I have problem to connect report with MSaccess 2007-2013 data base protect by password

I get the following error message:
Logon failed.
Details: ADO Error Code: 0x80040e4d.
Source: Microsoft Access Database Engine.
Description: Cannot start your application. The workgroup information file is missing or open exclusively by another user.
SQL State:3028
Native Error: -124520301 [Database Vendor Code : -124520301 ]

please help me

[wes4dbt]

Need more information. Are you trying to connect using the report designer or at runtime? If at runtime, provide the code. I normally don't connect directly to the database. I create a Typed Dataset and use that to design the report. The connection string for the dataset looks like this,

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=J:\YOURDATA\YOURDBNAME.mdb;Persist Security Info=True;User ID=admin;Jet OLEDB:Database Password=MILK1960

This example use the MS Jet provider, you would need to change that to the ACE

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword

[honest]

the problem is not in code or in provider it's in the database, the database in exclusive mode when I set password to database
but if the database not have password the connection is work without any problem

[wes4dbt]

I just showed you how to connect to a database with a password and you didn't answer any of my questions. Good luck

[honest]

any one help me please