469,336 Members | 5,643 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

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?
Nov 12 '05 #1
4 10256
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" <dj****@hotmail.com> wrote in message
news:%D*******************@newssvr25.news.prodigy. com...
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?

Nov 12 '05 #2
10-4

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

"MacDermott" <ma********@nospam.com> wrote in message
news:OU******************@newsread1.news.atl.earth link.net...
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" <dj****@hotmail.com> wrote in message
news:%D*******************@newssvr25.news.prodigy. com...
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?


Nov 12 '05 #3
"deko" <dj****@hotmail.com> wrote in message news:<%D*******************@newssvr25.news.prodigy .com>...
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?


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.
Nov 12 '05 #4
"deko" <dj****@hotmail.com> wrote in news:BhROb.12962$_s6.10916
@newssvr25.news.prodigy.com:
10-4

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


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)
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by James Knowlton | last post: by
5 posts views Thread by Markus | last post: by
4 posts views Thread by TycoonUK | last post: by
reply views Thread by Geary | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.