Data Access for a "mdb" file using a web form

Hi I am Arun. My question is about the data access methods available in C# in web forms. I have a simple database file in MS Access with three columns, EmployeeID, FirstName and LastName. I am trying to just display these onto the form through a label as explained in a couple of reference books. I tried typing out the code exactly as it is and then tried changing it little by little. I used the Server explorer and the Data Controls on the toolbox in VS.Net, to bind my table - i have only one table - and there is an error in some or the other line. THe main error message i get is "The Microsoft Jet database engine cannot open the file 'C:\Documents and Settings\robotfan\Desktop\students.mdb'. It is already opened exclusively by another user, or you need permission to view its data. " Please explain what is going wrong here.. is it that I dont have user permissions on the computer or is something wrong with the code. I tried out the code posted by Gustavo Pares on 01/14/2003 under the title "From DAO to ADO.Net" on this web site. Thanks Arun

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

tsuman_in22y ago
You have the access file open while you're trying to access the file. The MS Jet provider only allows 1 connection to an Access database so you can't have the file open. I suggest you install the MS SQL Server 2000 MSDE, which is a free version of SQL Server you can download from MSDN.