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 12:56:53 -0500

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