Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

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
Avatar of VBRocks
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answers