ms access runtime error 3251 split database

Specially when the created connection differs from the one you can do with Data /Connections. I have read a couple of posts but with Power Query being so new wouldn't think the same solutions can be applied here. At time I even have to reboot the computer so that i can refresh the rest. I understand that the first connection left the database open though I do not know how to close it and advance without having to close the Excel and start over with the next query. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.

that prevents it from being opened or locked'. Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

An error message appears with the text 'The database has-been placed in a state by user 'Admin' on machine. The issue is that when I try to refresh connections with 'Refresh all' the first one usually I have an Excel file that is connected to several queries from an Access database by using Power Query (both reside in a local server C:).

For the past two months, I have been struggling with an error that can fixed manually but for which I would like to find a more permanent solution.

Ms access runtime error 3251 split database