Newbie needs help with Access+OLEDB
-
Hi fellas. I am trying to do a simple registration system with MS Access. Currently I am using Access 2003, along with C# is VS.NET 2003. The thing is, whenever I am executing the database connections part, I get this error:
The Microsoft Jet database engine cannot open the file 'C:\SamsTestData\Member.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:\SamsTestData\Member.mdb'. It is already opened exclusively by another user, or you need permission to view its data.I have absolutely no idea what is going on. I tried googling the web, however I am clueless, as well as where I should start. I am guessing I have to tinker with some settings, but where??? :sigh: Anyway help would be greatly, greatly appreciated! THANKS!!! :-D -
Hi fellas. I am trying to do a simple registration system with MS Access. Currently I am using Access 2003, along with C# is VS.NET 2003. The thing is, whenever I am executing the database connections part, I get this error:
The Microsoft Jet database engine cannot open the file 'C:\SamsTestData\Member.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:\SamsTestData\Member.mdb'. It is already opened exclusively by another user, or you need permission to view its data.I have absolutely no idea what is going on. I tried googling the web, however I am clueless, as well as where I should start. I am guessing I have to tinker with some settings, but where??? :sigh: Anyway help would be greatly, greatly appreciated! THANKS!!! :-DA few clues: 1) Is the MDB open in Microsoft Access IDE, typically any table in its design view? If yes, then preferably close them. 2) http://support.microsoft.com/kb/174943[^] 3) Is MDB Path writeable by ASP.NET?
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
-
Hi fellas. I am trying to do a simple registration system with MS Access. Currently I am using Access 2003, along with C# is VS.NET 2003. The thing is, whenever I am executing the database connections part, I get this error:
The Microsoft Jet database engine cannot open the file 'C:\SamsTestData\Member.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:\SamsTestData\Member.mdb'. It is already opened exclusively by another user, or you need permission to view its data.I have absolutely no idea what is going on. I tried googling the web, however I am clueless, as well as where I should start. I am guessing I have to tinker with some settings, but where??? :sigh: Anyway help would be greatly, greatly appreciated! THANKS!!! :-D -
A few clues: 1) Is the MDB open in Microsoft Access IDE, typically any table in its design view? If yes, then preferably close them. 2) http://support.microsoft.com/kb/174943[^] 3) Is MDB Path writeable by ASP.NET?
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
Thanks for your swift reply. I have closed the MS Access application when executing the page. I guess that is good enough? I did went to the link you provided before I asked for help in here. However I just baffled by the terminology that's in there. How do you determine whether the MDB path is writable in ASP.NET? Is the settings set in Access, VS.NET 2003, or from the Internet Information Services in the Administrative Tools of the Control Panel? Thanks a bunch and looking forward to your reply!
-
do u have the Database already opened somewhere??
Rocky You can't climb up a ladder with your hands in your pockets.
Thanks for the swift response. Nope, I had MS Access closed when the webpage is being executed. So I am just perplexed at what could be the culprit. Any other ideas? Thanks!!!
-
Thanks for the swift response. Nope, I had MS Access closed when the webpage is being executed. So I am just perplexed at what could be the culprit. Any other ideas? Thanks!!!
-
Is this File accessible by all kind of users?? may be u have some permission problems. Have you read that article mentioned by another friend of mine
Rocky You can't climb up a ladder with your hands in your pockets.
Thanks for the reply. Which article are you referring specifically? I'm stumped whether I should be looking at Access, VS.NET 2003, or the IIS in the Administrative Tools...or is it somewhere else I should be looking at? Thanks again.
-
Thanks for the reply. Which article are you referring specifically? I'm stumped whether I should be looking at Access, VS.NET 2003, or the IIS in the Administrative Tools...or is it somewhere else I should be looking at? Thanks again.
http://support.microsoft.com/kb/174943[^][^] Thats the one I was talking abt well first you should look for permissions on the file itself u know right click the file>properties>permissions... make it accessible by the 'Everyone' Account. you should also keep an eye on the folder permission in which taht file resides. if its still not helping the refer to IIS which is some thing I dont know too much about :->
Rocky You can't climb up a ladder with your hands in your pockets.
-
Hi fellas. I am trying to do a simple registration system with MS Access. Currently I am using Access 2003, along with C# is VS.NET 2003. The thing is, whenever I am executing the database connections part, I get this error:
The Microsoft Jet database engine cannot open the file 'C:\SamsTestData\Member.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:\SamsTestData\Member.mdb'. It is already opened exclusively by another user, or you need permission to view its data.I have absolutely no idea what is going on. I tried googling the web, however I am clueless, as well as where I should start. I am guessing I have to tinker with some settings, but where??? :sigh: Anyway help would be greatly, greatly appreciated! THANKS!!! :-DInfernojericho wrote:
An unhandled exception occurred during the execution of the current web request
Ok, this seems to be an ASP.NET issue, so this is not the right forum. Anyway, from the message given, I would say that ASP.NET doesn't have the necessary permissions to open the file. The folder in which the file is located was, I suppose, created by you, so by default, ASP.NET doesn't have any permissions set for this folder. You need to look into that matter by checking the
properties->Securitytab of the folder and making sure that the local user ASPNET has permissions to at least read the file. You would also need the write/modify permissions to be able to write into the file.-- If this is a post that has been helpful to you, please vote for it. Thank you! "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." --Rich Cook
-
Infernojericho wrote:
An unhandled exception occurred during the execution of the current web request
Ok, this seems to be an ASP.NET issue, so this is not the right forum. Anyway, from the message given, I would say that ASP.NET doesn't have the necessary permissions to open the file. The folder in which the file is located was, I suppose, created by you, so by default, ASP.NET doesn't have any permissions set for this folder. You need to look into that matter by checking the
properties->Securitytab of the folder and making sure that the local user ASPNET has permissions to at least read the file. You would also need the write/modify permissions to be able to write into the file.-- If this is a post that has been helpful to you, please vote for it. Thank you! "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." --Rich Cook
That was a helpful reply. Finally got it working. And of course, gave it a 5-star vote. Thanks again!