troubleshooting Question

"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. "

Avatar of piyushdabomb
piyushdabomb asked on
.NET ProgrammingVisual Basic.NET
7 Comments1 Solution1022 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros