unable to open access database

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

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

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.

Problem resolved

thanks for you help

Steve