Cannot Open A97db, But Can Open A2k db

<i><b>Originally posted by : KevinM (mullarkey@fs5.ee.umist.ac.uk)</b></i><br />Here's the situation....<br /><br />I have an Access2000 db and can open it fine with my dbconnection file which is....<br /><br /><%<br />set conn = server.createobject("adodb.connection")<br />conn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../fpdb/123PPE.mdb")<br />conn.open<br />Set rst=Server.CreateObject("ADODB.Recordset")<br />%><br /><br />BUT, when I convert the db to Access97 it works fine om my PWS, but it won't work on my client's web werver. She can use the Access2000 version OK, but the A97 version (which se re-names correctly) she keeps getting the following error on the asp pages...<br /><br />"Microsoft OLE DB Provider for ODBC Drivers error '80004005'<br /> <br />[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'.<br />It may not be a database that your application recognizes, or the file may be corrupt."<br /><br />She has converted the db from 2k to 97 correctly.<br />She has done all the usual ticking/unticking of the DAO, ADO references, compiled and saved etc in Access and the A97 version runs fine from within Access and fine on MY web server.<br /><br />Her client MUST use the A97 version and NOT the A2k version.<br /><br />Does anybody have any ideas on how I can get the A97 version running on her web server.<br />Is it the server or Access at fault and could it have something to do with the ODBC/OLE DB drivers, and if so what?<br /><br />Many Thanks, I appreciate any help with this, as I am really stumped<br /><br /><br />Kevin M<br /><br />