How do I delete a table in Access 2016?

How do I delete a table in Access 2016?
LVL 2
RyanHelp DeskAsked:
Who is Participating?
 
☠ MASQ ☠Connect With a Mentor Commented:
It's in use in your database at the moment.

You can open Access without "Movies to Keep" being open by double-clicking on your database file while holding down the shift key.

You might want to try Rename first though just in case deleting it breaks something in your database. Then relaunch - if Access doesn't complain about you renaming the table then you can probably delete it with no issues.  

Deleting in Access isn't quite like deleting a file in Windows - once it's deleted that's it.  The only way back is to have made a backup of your database first!
0
 
☠ MASQ ☠Commented:
Same as earlier versions, in Table view right-click on the table in the right-hand column and choose delete.
0
 
RyanHelp DeskAuthor Commented:
how do I see the table view?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
John TsioumprisSoftware & Systems EngineerCommented:
Right click the table ==> Delete
Clipboard02.jpg
0
 
☠ MASQ ☠Commented:
^^ What he said :)
The arrow on the right lets you switch between Queries, Tables, Reports etc.
0
 
RyanHelp DeskAuthor Commented:
Expert Comment
by:John Tsioumpris
Schedule LIVE session
Software & Systems Engineer
ID: 42545536
1m
Right click the table ==> Delete

Getting this:

Capture.JPG
0
 
John TsioumprisSoftware & Systems EngineerCommented:
The table is being used....close your Access and reopen it...preferably holding Shift to disable any code..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.