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 10:27:12 -0500

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: Could not lock file Error
    ... I am getting the error when i am filling my dataset (Line 73: ... >> i am trying to connect to an Access Database that resides on the C drive ... >> my computer and am trying to populate the dataset using the data i got ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Could not lock file Error
    ... DISTINCT Department FROM order by Department" ... > i am trying to connect to an Access Database that resides on the C drive ... > now my problem is, while trying to populate the dataset, its giving me the ... > Could not lock file. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Hard to explain - multiple update fields query...
    ... There are 300 awards in the Precedence Table I used to populate the ... AwardsTable in your Access database and do all the work there. ... You will need 40 queries to populate the table from your current table. ...
    (microsoft.public.access.queries)
  • Re: using WMI for computer inventory
    ... > This is a MySQL back-end with an audit script that runs and populates the ... > option to populate an Access database without changing the background (its ... > HTA front-end that queries remote computer info, however, there is no db ...
    (microsoft.public.windowsxp.wmi)
  • Re: Populating a list box from a database
    ... > Dim rs As DAO.Recordset ... > ' Load the ListBox with the retrieved records ... >> Can I populate a list box in word from values within an access database? ...
    (microsoft.public.word.vba.general)