2. ASPRunnerPro General questions
  3. Error on View in Browser
This topic is locked

Error on View in Browser

 		7/24/2003 10:45:58
ASPRunnerPro General questions
author

Error number -2147467259

Error description [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
I am testing the application against a simple MS Access Db on my locak machine running Win XP and IIS and get this error. I'm using the Local Web Serve root dir for output
any ideas
Sergey Kornilov admin 7/24/2003

Jerry,
it sounds like your database file is open in Excel while you trying to access it through ASP.
Read this article from Microsoft for more info:

http://support.microsoft.com/default.aspx?...&NoWebContent=1
Sergey Kornilov
500055 7/24/2003

Jerry,

it sounds like your database file is open in Excel while you trying to access it through ASP.
Read this article from Microsoft for more info:

http://support.microsoft.com/default.aspx?...&NoWebContent=1
Sergey Kornilov



I'm running against a MSAccess db which is closed .. I cereated the db then closed access then used ASPRunner ... then got the error
Sergey Kornilov admin 7/27/2003

Jerry,
your error message says that you use Excel ODBC driver while connecting to MS Access database.
Probably you have linked table in MS Access that points to Excel file. This link won't work on ASP page. I would recommend to import your Excel data into MS Access.
Sergey Kornilov