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
Line 136: If objConnection.State = ConnectionState.Closed Then objConnection.Open()
Line 137:
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?
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
Line 136: If objConnection.State = ConnectionState.Closed Then objConnection.Open()
Line 137:
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?
daveamour
What kind of server is it & do you have control over the server?
ASKER
No I don't
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
VBRocks,
What's nice about Excel and Access is that I can write to the files without any SQL (just copy/paste data). Is there a way to do the same thing using SQL?
How can I also test my sql express on my client/server given that I'm using a 3rd party vendor?
What's nice about Excel and Access is that I can write to the files without any SQL (just copy/paste data). Is there a way to do the same thing using SQL?
How can I also test my sql express on my client/server given that I'm using a 3rd party vendor?
"3rd party vendor"? you mean that your website is hosted somewhere else, like "godaddy", or something?
ASKER
Its actually www.mosso.com
They provide an FTP/Server for us to use. What's nice about Excel and Access is that its super easy to copy/paste information into files and then use the documents by treating them like a database (rather than using SQL to read/write to the database).
Anyone have any thoughts on this?
They provide an FTP/Server for us to use. What's nice about Excel and Access is that its super easy to copy/paste information into files and then use the documents by treating them like a database (rather than using SQL to read/write to the database).
Anyone have any thoughts on this?
ASKER
While the respondent mentions "terrible back-ends for a website", there has to be a way to work around the issue.