Problems with Microsoft Jet database engine 4.0 and accessing data.

<i><b>Originally posted by : Steffi (stefanie@prokaria.com)</b></i><br />I am working on a little application, aspx pages and web services. I use MS Access for a database. All the time I try to get the results of a query I get the following error:<br /><br />"System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Exception ---> System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:InetpubwwwrootNjalssagaNjalssaga.mdb'. It is already opened exclusively by another user, or you need permission to view its data. at......." <br /><br />The database is neither open nor used by someone else. On the web I found million people who had the same problem but I didn´t find a single answer to it. At work I use the same stuff and it works properly. Does anyone know what the problem is? There is no access regulation on that database. I am very greatful for some advice! Thank you Steffi

<i><b>Originally posted by : Gary Halpin (itsg@aol.com)</b></i><br /><br />I have experienced the same problem and could not find a decent solution. Someone with more time than I have will have to figure it out. However, the problem appears to be that the mdb somehow becomes corrupted. A fix that worked was to create a new mdb and then import all of the tables from the "corrupt" mdb. Then I then renamed the "corrupt" mdb to something else and then renamed the new mdb to the name of the "corrupt" mdb and the problem disappeared.<br />Hope this helps you.<br /><br />------------<br />Steffi at 8/11/2002 1:55:30 PM<br /><br />I am working on a little application, aspx pages and web services. I use MS Access for a database. All the time I try to get the results of a query I get the following error:<br /><br />"System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Exception ---> System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:InetpubwwwrootNjalssagaNjalssaga.mdb'. It is already opened exclusively by another user, or you need permission to view its data. at......." <br /><br />The database is neither open nor used by someone else. On the web I found million people who had the same problem but I didn´t find a single answer to it. At work I use the same stuff and it works properly. Does anyone know what the problem is? There is no access regulation on that database. I am very greatful for some advice! Thank you Steffi

<i><b>Originally posted by : Steffi (stefanie@prokaria.com)</b></i><br />Thank you Gary, I will try this! <br /><br /><br />------------<br />Gary Halpin at 8/11/2002 6:47:34 PM<br /><br /><br />I have experienced the same problem and could not find a decent solution. Someone with more time than I have will have to figure it out. However, the problem appears to be that the mdb somehow becomes corrupted. A fix that worked was to create a new mdb and then import all of the tables from the "corrupt" mdb. Then I then renamed the "corrupt" mdb to something else and then renamed the new mdb to the name of the "corrupt" mdb and the problem disappeared.<br />Hope this helps you.<br /><br />------------<br />Steffi at 8/11/2002 1:55:30 PM<br /><br />I am working on a little application, aspx pages and web services. I use MS Access for a database. All the time I try to get the results of a query I get the following error:<br /><br />"System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Exception ---> System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:InetpubwwwrootNjalssagaNjalssaga.mdb'. It is already opened exclusively by another user, or you need permission to view its data. at......." <br /><br />The database is neither open nor used by someone else. On the web I found million people who had the same problem but I didn´t find a single answer to it. At work I use the same stuff and it works properly. Does anyone know what the problem is? There is no access regulation on that database. I am very greatful for some advice! Thank you Steffi