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 14:29:46 -0500

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

  • Re: How to use access query computed fields in Word mailmerge
    ... Once you have gone through the connection process once, ... To make a DDE connection in code from Word 2000/2002 I think you will need ... My access databases have lots of these computed query ... >>> an access database with any data in it. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How to stop source prompt in mail merge from access
    ... Are you calling OpenDataSource in your Access code? ... connection from the Word mail merge main document because Word will try to ... > The mail merge is being called from the Access database via a Visual Basic ...
    (microsoft.public.word.mailmerge.fields)
  • Re: error messages when connecting to an MS Access query
    ... I'm actually opening the Word document from VBA in the Access database, ... It's actually easy to run a Make Table query in Access, ... I got messages saying it couldn't make the connection. ... When you try to make a DDE connection, if the database is not already ...
    (microsoft.public.word.mailmerge.fields)
  • Re: JDBC Applets - MS Access
    ... > I am working on a Applet at the moment which must be able to access ... > I need to be able to setup a jdbc connection to an Access database. ... JDataConnect also uses a server side JDBC server. ...
    (comp.lang.java.databases)
  • Re: connecting to a database
    ... install at Beta sites, I would like to use an Access Database to store ... I have no idea how to set up a connection. ... connection to an Access Database that they would be willing to post. ... There are no real JDBC driver for MS Access. ...
    (comp.lang.java.programmer)