DataAdapter.fill() causes error

[yma]

Hi,

I tried to display a column in MS Access 2000 nwind.mdb. But I got "It is
already opened exclusively by another user, or you need permission to view
its data." It caused by OleDbDataAdapter1.Fill(DataSet11, "employees") in
page_load sub.

Then I tried to use my local sql server 2000. SqlDataAdapter1.fill() caused
an unhandled system error. Could you show me how to fixed them?

Thank you a lot.
Chris

 

[Cor]

Hi Yma,

I would also ask this question in the ADO.NET group, the guys in the very
active

microsoft.public.dotnet.framework.adonet

newsgroup see this probably a lot of times.

Cor

 

[yma]

I could not display data in listview control. Could you try to use the data
control to display data?

Thank you.

 

[Nitromuse]

I've run into the same situation using Excel simply
because I accessed a cell and changed the data but did
not 'Enter' it, (move to another cell), thus hung up the
access to the refered App. Bet this is your thing too,
let me know if it helps. NM

 

[Nitromuse]

I was working with VB.net and Access yesterday and had to
totally close the Access database before I could update
from VB to Access, which isn't the case with Excel.