Re: Could not lock file Error
From: krishna c kanthety (kkanthety@metrobat.com)
Date: 11/26/02
- Next message: John: "Re: HELP PLEASE The request failed with HTTP status 401: Access Denied."
- Previous message: Val Mazur: "Re: Could not lock file Error"
- In reply to: Val Mazur: "Re: Could not lock file Error"
- Next in thread: Val Mazur: "Re: Could not lock file Error"
- Reply: Val Mazur: "Re: Could not lock file Error"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "krishna c kanthety" <kkanthety@metrobat.com> Date: Tue, 26 Nov 2002 13:36:30 -0500
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
> >
> >
>
>
- Next message: John: "Re: HELP PLEASE The request failed with HTTP status 401: Access Denied."
- Previous message: Val Mazur: "Re: Could not lock file Error"
- In reply to: Val Mazur: "Re: Could not lock file Error"
- Next in thread: Val Mazur: "Re: Could not lock file Error"
- Reply: Val Mazur: "Re: Could not lock file Error"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
