Problems accessing SQL Server or MS-Access databases

[carya808]

I receive the following error when attempting to connect to either an MS-Access database using the OLEDbDataAdapter while testing a .Net Web application using a datagrid, repeater, etc.
The Microsoft Jet database engine cannot open the file 'C:\myPath\myData.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

This error occurs consistently when attempting to 'fill' the DataAdapter,
eg: OleDbDataAdapter1.Fill(DataSet11, "tblUsers")


I receive this error only in Visual Studio when testing Web apps. I don't
receive it when testing, for example, a .Net VB app. Likewise, if I code
a .Net Web app outside of Visual Studio (saved as .aspx), everything
works fine, whether accessing an Access database or SQL Server 2000.

Any help with this would be much appreciated. I've tried everything I can
think of with no success.

- Thanks

 

[kulrom]

Check this out

 

[kulrom]

Hey, wellcome to the forum
Happy coding