Hi

I'm a beginner. Hope you can help.

I have an Access database I am trying to connect to. In Visual Basic, the connection string I provided works fine as a Windows applications, but when I use the same string as an ASP.NET application to try and get data to bind into a DataGrid, I get the error message that the Microsoft Jet engine cannot open the file ... "It is already opened exclusively by another user, or you need permission to view its data." I'm guessing its a problem with permissions, but how do I sort that out? The .mdb file is located in the same folder as the web application files - c:\inetpub\wwwroot\webapplication1.

Any help is much appreciated!

Eric

Fairly obvious point - do you have th database open in Access when you are trying to view the page? Occasionally I get similar errors when viewing a database page and the database is open.

Might be worth putting it in a subfolder (e.g. dBase) - this is good practice since most hosts only allow databases to be utilised in certain folders. This way you can set permissions etc. of this folder without affecting the application directory.

What is the connection string/code you are using?