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

[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

-----Original Message-----
Hi,

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

Then I tried to use my local sql server 2000. SqlDataAdapter1.fill() causedan unhandled system error. Could you show me how to fixed them?
Thank you a lot.
Chris
.

[yma]

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

Thank you.
"Nitromuse" <an*******@discussions.microsoft.com> wrote in message
news:02****************************@phx.gbl...

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

-----Original Message-----
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
.

[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.

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

Thank you.
"Nitromuse" <an*******@discussions.microsoft.com> wrote in messagenews:02****************************@phx.gbl...

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

>-----Original Message-----
>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
>
>
>.
>

.