ASP Database Problem

I hope there's a genius ASP programmer out there somewhere. I'm having a real problem with a client's ASP website that I just cannot understand or solve.<br><br>Ten points to the anyone that can help!!<br><br>The site is a car sales website which has an Access database with car details (make, model, price, etc). There is a basic search tool on the site that accepts a string and matches it against the make/model and displays the results.<br><br>Now, this is normally fine, but on the odd occasion, it will produce an error when trying to connect:<br><br>[Microsoft][ODBC Microsoft Access Driver]General error Unable to open<br>registry key 'Temporary (volatile) Jet DSN for process 0x854 Thread 0x980<br>DBC 0x2255c84 Jet'.<br><br>The 'Unable to open registry key' error, as I understand it, normally means that the script was unable to open the database. But I can't understand why it can on some occasions, but not on others. Every time the search is complete and results have been shown, the script closes the recordset and connection and frees the resources. So the database should never be locked.<br><br>My host says it must be a code problem as other websites on the same server are not having a problem. I don't see how it can be the code, because the problem is very intermittent - there is no pattern to the error log file I've set up.<br><br>Anyone got any ideas? <br><br>Paul<br><br>[- Please add your name at www.fijjit.com -]

Just a thought - Are you returning your ADODB.Recordset as a forward only, client cursor, & disconnected?

The Error is sent when you try to access to msaccess memo fields ? The memo field are many problem. <br><br>If you use msaccess database try to convert in 2002 format.<p> </p><p><hr size="1" width="50%" align="left" />Giuseppe Giardina<br>http://www.storeportal.com<br>Media Online Italia s.r.l.<br>Via Nino Bixio, 27/a<br>70017 Putignano (BA)<br>Italy<br>Email: info@storeportal.com</p>

I would have to disagree with what is been written above about the memo fields. Memo fields are a major problem but i don't think it is the cause of your error.<br><br>Just had a quick look at MS Support its just a quick thought but try repairing your database under Tools menu in Access, point to Database Utilities, then Repair.<br><br>Keep in touch would like to know about your search and if it is dynamic and will search through memo fields<br>L8r

Memo fields shouldn't cause any kind of connectivity problem and are fully searchable through SQL or ASP. Are you sure no-one else is opening the DBase? Are there any webAccess pages being used? Does the Dbase backup regularly on some kind of auto schedule? Any of these things could fail the connection. Are you opening a recordest object or just a connection object - is the Dbase used to feed dynamic pages elsewhere and how many concurrent connections could there be? If the pages are taking a bit of time to load have you tried using getRows and searching the array rather than iterating the Dbase?

Thanks, guys.<br><br>I eventually solved this by upgrading the DB to Access 2000 (well done, Giuseppe). A pain in the ***, but it appears to have worked. <br><br><br>Paul<br><br>[- Please add your name at www.fijjit.com -]