What locks a table?

[Steven Bierer]

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

[Brent]

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

[Steven Bierer]

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

[Sue Harsevoort]

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

[Phil N.]

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