Connecting to Access Database

[jim31]

Hi,

I am brand new to ASP.net and I have setup a very simple access database on my desktop that I am trying to connect to through using MS Jet 4.0 provider.

However, no matter what I do I cannot open the database when I build and browse. I get an error saying the file is either opened exclusively or you do not have permissions to view this file. Yet, in development (Solution Explorer) I can play with the datasource.

I am guessing maybe this has something to do with IIS rights? I don't know. I am the admin on the machine.

I would be grateful for any guidance!

Thanks,
Jim

[MarkusJ_NZ]

Hi, right click on the database and then select properties then the security tab.

You want to add the ASPNET user to the list of people who have rights to this database (Click Add and then select ASPNET from the list of available users). Give the ASPNET user Read/ write/ modify and see how you get on

HTH
MarkusJ

[hellswraith]

Also, you say that "Yet, in development (Solution Explorer) I can play with the datasource." which may be blocking access to the db because the solution explorer is connected at the time. You can rightclick on the DB in the DB Explorer, and disconnect.