unable to open access database

[steve_rm]

Hello

I have set up a ASP web application. I am using access database and using a datagrid to display the information.

The problem l get is a error saying that "unable to open database due to another user using it, or i do not have permission rights to view the data. But the data base is not open by anyone else and l do have rights to view the data.


Any ideas

Many thanks in advance

Steve

[steve_rm]

Hello

Just giving the code that l am using and the error message it gives me.

C:\Surgery.mdb. It is already opened by another user, or you need permission to view its data.

My code l am using is the following

[code]
daOwners.Fill(dsOwners) 'Fill the dataset with the contents of the database
grdOwners.DataSource = dsOwners 'Put the data from the dataSet into the datagrid
grdOwners.DataBind() 'Bind the contents

[\code]

I get the error message on the first line "daOwners.Fill(dsOwners)

Hope someone can help me

Many thanks in advance

Steve

[CVMichael]

Try setting the database permissions to ASPNET user, it's the same user that ASP .NET runs on... i had similar problems, and that solved it...

If you do Ctrl + Alt + Del, and click on processes tab, you will see that aspnet_wp.exe runs on ASPNET user name.

[steve_rm]

Problem resolved

thanks for you help

Steve