Close the form or report bound to the table. There is no need to close the
table explicitly, nor is there any reason why the table should be available
to the user, and therefore no reason to open or close the table.
Well actually the table needs to be closed to be deleted.
By bumbling around I have finally found that right-clicking on the tab
that has the name of the table
will give me a menu with an option "close table".
After closing the table I am able yto delete it.
I have always closed a table by using the X in the top right corner. I
assumed you were trying to close it in a run-time situation. Perhaps you
are using Access 2007? I am not very familiar with the user interface for
that version.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.