I have been working on an ASP .NET (c#) project in visual studio .net in which the user submits a number into an access database. I've gotten everything working correctly when testing on my local machine and local IIS server. I can submit a number to the database and everything works fine.
The problem comes when I try to copy the project over to the server I'm required to use. The only method i've been given to publish files is through frontpage extensions, which is still not a problem because visual studio gives me the option to publish to a frontpage server.
I can upload everything just fine and my asp .net code works, but when I try to submit a number to the database I get the following error:
Status: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'd:\Inetpub\wwwroot\testing\ip\db\hcdb.mdb'. It is already opened exclusively by another user, or you need permission to view its data. at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at head_count2.WebForm1.btnSubmit_Click(Object sender, EventArgs e)
Now I have had this error before on my local machine, and I just had to change the permissions of the folder and the database. After playing with the permissions everything worked fine on my _local_ machine.
With frontpage extensions i have no options to change permissions or anything, but I am thinking that I should not have to, because when i create a database project in frontpage using asp .net. It is able to connect to and use an access database just fine, but thats using the frontpage database wizard.
So right now I'm pretty much lost as to what I should do, and as a last resort i wound up here hoping that someone will point out where I am going wrong.
Let me summarize what I do when I publish my project.
1. make sure everything runs fine on loal machine.
2. change path to database in the ConnectionString to the correct path on the remote server.
3. Save, build project.
4. go to Project->copy project ->frontpage access method, copy all source files in project folder
5. test by accessing the web URL,
Thank you for your help guys.