Re: Could not lock file Error

From: Val Mazur (group51a@hotmail.com)
Date: 11/26/02 

From: "Val Mazur" <group51a@hotmail.com>
Date: Tue, 26 Nov 2002 15:02:23 -0500

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