Hi,

I am storing database from my website using OLEDB connection for ACCESS Database. When i press the button to save the data it not storing anything into the database.

 Look at the connection string:

Conn.Connectingstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Sever.Mappath("Mydatabase.mdb") 

 I haven't specified  "User Id=admin;Password=;"  with the connection string. I would like to ask you, is it neccessary to use userid and password to the connection string or is there any other cause that the data is not storing into the database.

Thanks.

Best Regards

Arshad 

I doubt that Sever.Mappath("Mydatabase.mdb") is returning the right path for you...

Where is your db?

1) put it in the App_Data folder.
2) try Sever.Mappath("~/") & "App_Data/Mydatabase.mdb"

Curt_C:

I doubt that Sever.Mappath("Mydatabase.mdb") is returning the right path for you...

Where is your db?

1) put it in the App_Data folder.
2) try Sever.Mappath("~/") & "App_Data/Mydatabase.mdb"

Thanks for reply.

My database is in the root directory, so its working fine on my system but when i upload on my website, its not storing.

Before i keep my database in "App_Data/Mydatabase.mdb" but i was getting connection problem so i decided to keep in root directory. May be my connection string was wrong. I used before       Server.Mappath("~/App_Data/Mydatabase.mdb")

Thanks.

Regards

Arshad

ok, so I'm not sure if you are ok or not then?

Also, please check permissions... with an MDB you need to open up the FOLDER and the FILE permissions to the user context that calls it (typically ASPNET on the server) this is tricky and not always very secure.....

I check the properties on the web server of .MDB file.

I found the following one.

Permission : 666

Owner                                          Group                       Public

---------------------------------------------------------------------------------------------------

Read (Selected)                          (Selected)                (Selected)

Write (Selected)                          (Selected)                (Selected)

Execute(Not Selected)                (Not Selected)                 (Not Selected)

thanks.

 Is that for the .mdb file only or the directory holding the .mdb file?  I believe Access will create a temporary lock file on the directory also, but it's been a while since I use one (back in ASP classic days), so only giving read write access to the .mdb file itself might not be enough.  it will need to be able to create new file on the directory.  For that reason it might be best to move Access to its own folder and only allow that folder read write access.

geetasks:

Check whether using this connection string can you access data. If Yes, then there is no problem with your connection string.

I stored some data inside the .mdb file. Yes i can able to retrieve the data from the database. I already check this one.

Thanks.

Regards

Arshad

jchandra:

Is that for the .mdb file only or the directory holding the .mdb file? 

I didn't keep my .mdb file in a directory.  Its only .mdb file.

Thanks.

Regards

Arshad 

 check out the tutorial to connect / select / insert / update with Access DataBase > Connecting to a Microsoft Access database with ASP.NET

hope it helps./. 

Hi Kaushal,

Really i appreciate you for the information that you have provided for me. I hope this will solve my problem.

I read the article and i think this is the solution of my problem. Could you clarify my doubt. Look at the following URL :

http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/2/

I found some statement:

Replace the “computername” with your system name and “password” with the password of the “administrator” account.  You can also replace “administrator” with any other customized user account with respective privileges.  I simply demonstrated this using the “administrator” user account.

If i change the above one "Web.config". Hope this will work on my system but what about on my website.Could you tell  what will be the computername when i upload this database on my website. Do you mean my domain name here and ftp password here.

Thanks.

Regards

Arshad 

Hi,

I get an exception specifying "Operation must use an updateable query".

I read lot of articles and implemented based on this error but nothing works. Still i remains showing this exception.

Connecting to SQL Server is very easy but for .mdb file, its very hard.

I check in my system everything works fine, inserting, deleting and modifying data. But when i upload on the webserver and trying to save the data, i found the above exception.

I see that all the properties of the .mdb file, it contains read,write and execute mode.

Do anybody has some solution to this problem.

Thanks.

Best Regards

Arshad

Hi,

Do you think keeping the database in the root directory of website will also cause this problem.

Thanks.

Regards

Arshad

Putting the db in your root directory is not a safe practic at all.  You need to make sure that you restrict downloading of that file type.

I had an issue a couple of years ago with my access db not writing but everything else was working fine.  It turned out that I was trying to add the index number (an autonumber field). The app did not produce an error, and it took me for ever to figure out.  Access does it automaticly it seemed my quiry in VB was adding the autonumber with out me telling it.

bobmmp:

add the index number (an autonumber field). 

Yes I already added ID autonumber in the table.

Thanks

Regards

Arshad