Close all tables and queries

  • Thread starter Thread starter DZ
  • Start date Start date
In more recent versions of Access, you can programmatically discover if a
tabl is open like this:
CurrentData.AllTables("Table1").IsLoaded

You can close it like this:
DoCmd.Close acTable, "Table1"

Seriously, though, tables are queries are not adequate as the interface. If
you are programmatically writing code to manage the interface, you really
need to let the user only near forms and reports, and give them no access to
the tables and queries directly.
 

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

Similar Threads

loop and close all open tables 1
Record insert/delete anomaly 0
One to many help 4
OpenForm Does Not Update Embedded Query 4
Run query before closing database 1
Control a Query Datasheet with Code 2
Return to switchboard form when query closes 2
Repost: OpenForm Does Not Update Embedded Query 26

Back
Top