How do you close a table in Access 2007?

S

seaweed

Sorry - I am not used to microsoft ways. I can not find anywhere a
discussion of actions, buttons, menus, ANYTHING
that are used to close a table
 
A

a a r o n . k e m p f

it's called a macro

or in a module, you can use

Docmd.Close acTable "MyTable"

I think that is the syntax
 
B

BruceM

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.
 
S

seaweed

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.
 
B

BruceM

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.

Ask a Question

Top