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

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

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

Thank you.


"Nitromuse" <(E-Mail Removed)> wrote in message
news:02a601c3c189$91a5ac20$(E-Mail Removed)...
> 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
> >
> >
> >.
> >

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

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 data
>control to display data?
>
>Thank you.
>
>
>"Nitromuse" <(E-Mail Removed)> wrote
in message
>news:02a601c3c189$91a5ac20$(E-Mail Removed)...
>> 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
>> >
>> >
>> >.
>> >
>
>
>.
>