I'm having a difficult time trying to figure this out, but whenever I attempt to access the link:
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:
Line 134: & ";" & "Extended Properties=Excel 8.0;"
Line 135: Dim objConnection As New Data.OleDb.OleDbConnection
Line 136: If objConnection.State = ConnectionState.Closed Then objConnection.Open()
Line 138: Dim container As TabContainer = CType(TabContainer1, AjaxControlToolkit.TabCont
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?