How do I delete an unwanted table in Access?

[P. Bolden]

I have erroneously created a table that I do not need. I need to connect a
relationship between two other tables but this one is in the way. Can you
tell me how do I get rid of it?

 

[Stephen Raftery]

What is preventing you from just deleting it ?

Stephen

 

[Jeff Boyce]

Open the db. Go to the tables window. Highlight the table. Hit <delete>.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Clif McIrvin]

I have erroneously created a table that I do not need. I need to
connect a
relationship between two other tables but this one is in the way. Can
you
tell me how do I get rid of it?

Sounds like you might be talking about the graphical relationships
window ...

If so, you have at least three options:

1. Let the relationship line go "through" the third table graphic.
2. Right click in the third table's title bar and click "Remove Table"
3. Drag the third table's graphic out of the way.

or .. as others have advised, simply delete the unwanted table ...
assuming, of course, that it really is an unneeded table, and not just a
graphic where you don't want it.

Clif