Error Openning database.

Hello everybody...<br><br>My web application works fine, but when some different people try to open the databse, I get the following error...<br><br>Microsoft JET Database Engine error '80004005' <br>Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. <br>/fotografia/despliegafotoeng.asp, line 310 <br><br>The line of code where the error appears is when I try to open the database.<br><br>The application works fine, but when I put a link to my application in a public forum (when two or more people are trying to open the database, it crashes.)<br><br>I'm using Access 97 database.<br><br>I have contacted with support area , and they tell me that this error happens when 2 or more people are trying to open the database at the same specific time, but the problem is that the error remains until the server is restarted.<br><br>Is there any solution??<br><br>please help.<br><br>Roberto Ayala.

If people are actually opening the database I'm not surprised this is happening. It is actually the server that is opening the application and creating a lock file. When the user is finished the server still has the Dbase open and doesn't receive an instruction to close it. <br><br>If you want to provide info from a dbase to users you should use a connection object rather than accessing the dbase directly - this will allow you to open the connection, get the info and then close the connection. It also allows multiple concurrent connections which you cannot have if you open the dbase to an exclusive user.

Thanks Colin... <br>I'm using objects and yes, I'm closing them every time I open them, I found a solution , that is updating my database from Access 97 to Access 2002, I think the problem has been corrected doing this.<br><br>Thanks.<br><br>Roberto Ayala.<br>www.digitalfx3d.com