Not able to connect to MS Access DB as a Source in Power BI Desktop. “The database has been placed i

[medha_g_goyal]

I have Microsoft Access DB as Source db for Power BI Desktop. Error message : 

“The database has been placed in a state by user ‘Admin’ on machine… that prevents it from being opened or locked”

Aby suggestions please to resolve this error to be able to connect to MS Access DB in Power BI Desktop

[Anonymous · Accepted solution]

Hi  @medha_g_goyal ,

Workarond 1:

You can fix this issue by buffering the Access binary. Use the Binary.Buffer function in a query that defines your Access database, then reference that query in order to use the binary in a query that pulls each table.

Note: I also define parameters for my folder path and file names.

For example:

//myDbBinary
let    Source = Binary.Buffer(File.Contents(DataFolder_param & FileName_param), 
    [CreateNavigationProperties=true]))
in
    Source

// Table1 Query
let    Source = Access.Database(myDbBinary, [CreateNavigationProperties=true]),
    _Table1 = Source{[Schema="",Item="Table1"]}[Data]
in
    _Table1

For reference: Improving Power Query Calculation Performance With List.Buffer()

Workaround 2:

You can try to disable this option in power BI : 

"Enable parallel loading of tables" in Options --> Current File, Data Load

For reference: Error refreshing Access database data tables on a network in PowerBI desktop

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.