By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,501 Members | 831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,501 IT Pros & Developers. It's quick & easy.

How to force drop table?

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
"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

P: n/a
"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.