Access Databases in ASP.Net
-
I'm using an access database in my web project. I have two questions that I'm unsure about. After installing my web project on the host machine.....
It seems that I have to add read/write security permissions for the folder and
access mdb file for the ASPNET user. Is that the correct thing to do, or is
there another way around it. Without it I cannot update tables via my web project.Can the access database handle concurrent users/browsers reading and writing or
do I need to serialize the connections?-- modified at 16:15 Thursday 15th September, 2005
-
I'm using an access database in my web project. I have two questions that I'm unsure about. After installing my web project on the host machine.....
It seems that I have to add read/write security permissions for the folder and
access mdb file for the ASPNET user. Is that the correct thing to do, or is
there another way around it. Without it I cannot update tables via my web project.Can the access database handle concurrent users/browsers reading and writing or
do I need to serialize the connections?-- modified at 16:15 Thursday 15th September, 2005
If you can, using MSDE is a better option since it is compatible with SQL server and if you need to upgrade to a more powerful database you don't have to change any code.