How to force drop table?

I'm trying to delete a table with

db.execute DROP TABLE tempTable

I've tried first clearing the RecordSource of the forms that use tempTable
like this:

Me!RecordSource = ""

But it does not seem to help. I still get this error:

Error Number 3211: The database engine could not lock table 'tempTable'
because it is already in use by another person or process.

Is there a way to force drop this table? Or kill whatever has a lock on it?

re: How to force drop table?

No quick answers to the question you're asking, but an alternative
suggestion:

If you're regularly creating and dropping the same table,
it's often more efficient just to clear all the data out of it.

HTH
- Turtle

"deko" <dje422@hotmail.com> wrote in message
news:%DNOb.12946$Kz5.12369@newssvr25.news.prodigy. com...[color=blue]
> I'm trying to delete a table with
>
> db.execute DROP TABLE tempTable
>
> I've tried first clearing the RecordSource of the forms that use tempTable
> like this:
>
> Me!RecordSource = ""
>
> But it does not seem to help. I still get this error:
>
> Error Number 3211: The database engine could not lock table[/color]
'tempTable'[color=blue]
> because it is already in use by another person or process.
>
> Is there a way to force drop this table? Or kill whatever has a lock on[/color]
it?[color=blue]
>
>[/color]

re: How to force drop table?

10-4

I think the only thing to do is find what has a hold of the table...

"MacDermott" <macdermott@nospam.com> wrote in message
news:OUQOb.14956$i4.11308@newsread1.news.atl.earth link.net...[color=blue]
> No quick answers to the question you're asking, but an alternative
> suggestion:
>
> If you're regularly creating and dropping the same table,
> it's often more efficient just to clear all the data out of it.
>
> HTH
> - Turtle
>
> "deko" <dje422@hotmail.com> wrote in message
> news:%DNOb.12946$Kz5.12369@newssvr25.news.prodigy. com...[color=green]
> > I'm trying to delete a table with
> >
> > db.execute DROP TABLE tempTable
> >
> > I've tried first clearing the RecordSource of the forms that use[/color][/color]
tempTable[color=blue][color=green]
> > like this:
> >
> > Me!RecordSource = ""
> >
> > But it does not seem to help. I still get this error:
> >
> > Error Number 3211: The database engine could not lock table[/color]
> 'tempTable'[color=green]
> > because it is already in use by another person or process.
> >
> > Is there a way to force drop this table? Or kill whatever has a lock on[/color]
> it?[color=green]
> >
> >[/color]
>
>[/color]

re: How to force drop table?

"deko" <dje422@hotmail.com> wrote in message news:<%DNOb.12946$Kz5.12369@newssvr25.news.prodigy .com>...[color=blue]
> I'm trying to delete a table with
>
> db.execute DROP TABLE tempTable
>
> I've tried first clearing the RecordSource of the forms that use tempTable
> like this:
>
> Me!RecordSource = ""
>
> But it does not seem to help. I still get this error:
>
> Error Number 3211: The database engine could not lock table 'tempTable'
> because it is already in use by another person or process.
>
> Is there a way to force drop this table? Or kill whatever has a lock on it?[/color]

If any other open object is using it, then you have to close all of
those objects first. Why are you dropping the table? if it's a temp
table that won't get used again, put it in another database like Tony
Toews shows on his website. Otherwise, just delete all the records
from the table and use it over again as necessary.

re: How to force drop table?

"deko" <dje422@hotmail.com> wrote in news:BhROb.12962$_s6.10916
@newssvr25.news.prodigy.com:
[color=blue]
> 10-4
>
> I think the only thing to do is find what has a hold of the table...[/color]

Another thing is:
Scrap what you have done,
take the media on which it resides and throw it into a white-hot furnace,
learn a tiny bit about Access, Databases, and Programming,
.... and start all over.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)