Re: Could not lock file Error

From: krishna c kanthety (kkanthety@metrobat.com)
Date: 11/26/02 

From: "krishna c kanthety" <kkanthety@metrobat.com>
Date: Tue, 26 Nov 2002 15:58:13 -0500

I tried but of no use..its giving me the same error..could not lock file

"Val Mazur" <group51a@hotmail.com> wrote in message
news:eew9gbYlCHA.1748@tkmsftngp07...
> Hi,
>
> Try to use another SELECT from another table see if you get same error or
> not. Use something simple, like SELECT * FROM tablename
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "krishna c kanthety" <kkanthety@metrobat.com> wrote in message
> news:OPm9sIYlCHA.1924@tkmsftngp04...
> > Its an Access database and the test connection succeeded when i tested
> > it..so the connection is fine..
> > any ideas??
> >
> > "Val Mazur" <group51a@hotmail.com> wrote in message
> > news:e#6oJ5XlCHA.2456@tkmsftngp04...
> > > Hi,
> > >
> > > Which database is it? Are you able to establish connection to it?
> > >
> > > --
> > > Val Mazur
> > > Microsoft MVP
> > >
> > >
> > > "krishna c kanthety" <kkanthety@metrobat.com> wrote in message
> > > news:uNjTepXlCHA.2144@tkmsftngp02...
> > > > Val,
> > > > I am getting the error when i am filling my dataset (Line 73:
> > > > Me.OleDbDataAdapter1.Fill(DataSet11)
> > > > .....i put a space in between order and by, still i am getting the
> same
> > > > error..any ideas??
> > > > thanks
> > > > KC
> > > >
> > > > "Val Mazur" <group51a@hotmail.com> wrote in message
> > > > news:edFTbVXlCHA.1924@tkmsftngp04...
> > > > > Hi,
> > > > >
> > > > > Did you forget to add space in "order by" clause?
> > > > >
> > > > > Me.OleDbDataAdapter1.SelectCommand.CommandText = "SELECT
> > > > > DISTINCT Department FROM [Department Table] order by Department"
> > > > >
> > > > > --
> > > > > Val Mazur
> > > > > Microsoft MVP
> > > > >
> > > > >
> > > > > "krishna c kanthety" <kkanthety@metrobat.com> wrote in message
> > > > > news:uUKHs$VlCHA.2032@tkmsftngp02...
> > > > > > Hi All,
> > > > > > i am trying to connect to an Access Database that resides on the
C
> > > drive
> > > > > of
> > > > > > my computer and am trying to populate the dataset using the data
i
> > got
> > > > > from
> > > > > > the access database....
> > > > > > now my problem is, while trying to populate the dataset, its
> giving
> > me
> > > > the
> > > > > > following error
> > > > > > Could not lock file.
> > > > > > Line 72: Me.OleDbDataAdapter1.SelectCommand.CommandText
=
> > > > "SELECT
> > > > > > DISTINCT Department FROM [Department Table] orderby Department"
> > > > > > Line 73: Me.OleDbDataAdapter1.Fill(DataSet11)
> > > > > > Line 74: Dim dt As DataTable = New DataTable()
> > > > > >
> > > > > > can any body let me know where i went wrong..i gave the security
> > > > > permissions
> > > > > > for the file for ASPNET account..
> > > > > >
> > > > > > thanks in advance..Krishna Chaitanya Kanthety
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages