Access database opened exclusively by another user

Hi All,

I have several source xlsx. files saved on the drive (offline) and on the sharepoint. I am able to refresh the powerpivot via "existing connections" except for 1 file (see error message below). I have full control permission. The file is not in use by anyone else. I have re-loaded the source file in sharepoint, conforming the columns are correct, removed any blank rows etc. I don't know how to get my powerpivot refreshed with this error.

Error Message:
============================
The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.
----------------------------
Failed to connect to the server. Reason: The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.
============================
Call Stack:
============================
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
----------------------------
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.Open(String& connectionIdentifier)
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.Open()
at Microsoft.AnalysisServices.Common.DataSourceBasic.TestConnection()
at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl)

Please suggest me a proper solution for this problem, I had tried a lot but didn't found solution for this error.

This can happen if the permissions to view the file don't allow you to even read the directory contents. make sure that the file and directory are correctly shared and that you can navigate to it via exporer.

If you have already checked all of this then are you running Access front end with a different permission set to the logged on use?

Are you even using an Access front-end to Access back-end setup?

If the above does not help then please supply much more detail on how you are set up and what you are trying to do when you get this error

^_^

hope it will help you.string path = Server.MapPath(fileuploadExcel.PostedFile.FileName);

Add your solution here

 B   I   U   S  small BIG code var  <   >   &  link [^] encode untab case indent outdent

Preview 0

Existing Members

...or Join us

Download, Vote, Comment, Publish.

This email is in use. Do you need your password?

When answering a question please:

1. Read the question carefully.
2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
4. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

How do I turn off exclusive mode in Access?

How can I tell who opened my Access database?

How do I open an Access database for exclusive use?

Can multiple people have an Access database open?