Avatar of piyushdabomb
piyushdabomb

asked on 

"The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data. "

Hi,

I'm having a difficult time trying to figure this out, but whenever I attempt to access the link:

http://www.cebdata.com/DSSPrototype/FinalVersionWithDan/TotalRewardsUpdate-final.aspx

I receive the error message:
The Microsoft Jet database engine cannot open the file ''.  It is already opened exclusively by another user, or you need permission to view its data.

I have no reason to get this message because the database is open. And even if its open (note that I'm treating the database as an excel file), I should be able to allow multiple users access the file!

Here are some additional details:
Source Error:


Line 134:                    & ";" & "Extended Properties=Excel 8.0;"
Line 135:            Dim objConnection As New Data.OleDb.OleDbConnection(strConnection)
Line 136:            If objConnection.State = ConnectionState.Closed Then objConnection.Open()
Line 137:
Line 138:            Dim container As TabContainer = CType(TabContainer1, AjaxControlToolkit.TabContainer)
 

How can I possibly fix this situation? Note that the excel files permissions is currently set to 777 (read/write/etc...) and the web.config file has impersonation already on it!

Anyone have any bright ideas on getting this fixed?
.NET ProgrammingVisual Basic.NET

Avatar of undefined
Last Comment
piyushdabomb

8/22/2022 - Mon