DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: What locks a table?

  1. #1
    Steven Bierer Guest

    What locks a table?

    Dear All,

    'Error 3211: The database engine couldn't lock table 'MyTable' because
    it's already in use by another person or process.'

    Is there anyone that could enlighten me as to what could cause this
    error?

    I have checked the database object (DAO 3.51) to see how many recordsets
    are open, and it says that there are none open, so what else could cause
    a table to be locked?

    Any ideas on this would be *greatly* appriciated.

    --
    Steven Bierer
    bierer@editrack.com

  2. #2
    Brent Guest

    Re: What locks a table?


    Steve,
    If you are using Access, make sure that you do not have the table open for
    either viewing the data or editing the fields. The same could apply to other
    dbs as well...

    Brent

    Steven Bierer <bierer@editrack.com> wrote:
    >Dear All,
    >
    >'Error 3211: The database engine couldn't lock table 'MyTable' because
    > it's already in use by another person or process.'
    >
    >Is there anyone that could enlighten me as to what could cause this
    >error?
    >
    >I have checked the database object (DAO 3.51) to see how many recordsets
    >are open, and it says that there are none open, so what else could cause
    >a table to be locked?
    >
    >Any ideas on this would be *greatly* appriciated.
    >
    >--
    >Steven Bierer
    >bierer@editrack.com



  3. #3
    Steven Bierer Guest

    Re: What locks a table?

    Hi! Brent,

    Thanks for replying. I did forget to mention in my original post that I
    was using Access.
    Even if a table was being viewed or edited, wouldn't that register in
    the database object's Recordsets collection?

    Brent wrote:
    >
    > Steve,
    > If you are using Access, make sure that you do not have the table open for
    > either viewing the data or editing the fields. The same could apply to other
    > dbs as well...
    >
    > Brent


    --
    Steven Bierer
    bierer@editrack.com

  4. #4
    Sue Harsevoort Guest

    Re: What locks a table?

    The database object's Recordset collection will only show the recordsets
    that are opened in your code. If you or someone else has Access open and
    are doing something with the table that's not going to show up in the
    database object's Recordset collection.

    Sue

    Steven Bierer <bierer@editrack.com> wrote in message
    news:38E3BD0A.F2BFF8FB@editrack.com...
    > Hi! Brent,
    >
    > Thanks for replying. I did forget to mention in my original post that I
    > was using Access.
    > Even if a table was being viewed or edited, wouldn't that register in
    > the database object's Recordsets collection?
    >
    > Brent wrote:
    > >
    > > Steve,
    > > If you are using Access, make sure that you do not have the table open

    for
    > > either viewing the data or editing the fields. The same could apply to

    other
    > > dbs as well...
    > >
    > > Brent

    >
    > --
    > Steven Bierer
    > bierer@editrack.com




  5. #5
    Phil N. Guest

    Re: What locks a table?

    Hi Steve,

    It seems that the other person have opened database as exclusive mode.
    Double check so I doesn't happend!

    Sincerely

    Phil N.

    "Steven Bierer" <bierer@editrack.com> wrote in message
    news:38E3A786.360312D4@editrack.com...
    > Dear All,
    >
    > 'Error 3211: The database engine couldn't lock table 'MyTable' because
    > it's already in use by another person or process.'
    >
    > Is there anyone that could enlighten me as to what could cause this
    > error?
    >
    > I have checked the database object (DAO 3.51) to see how many recordsets
    > are open, and it says that there are none open, so what else could cause
    > a table to be locked?
    >
    > Any ideas on this would be *greatly* appriciated.
    >
    > --
    > Steven Bierer
    > bierer@editrack.com




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center