I have an Access 97 database that uses a large number of temporary tables. To save space my code creates the temporary tables in a new temporary database, and then I link the tables to the original database. Once I have finished with the tables I delete them with SQL e.g.
strSQL = "DROP TABLE [tblICIMIndex];"
DoCmd.RunSQL (strSQL)
Then I delete the temporary database, this gets around the problem of not being able to compress on close the Access 97 db. However, the table list still shows the tables that I had linked until I click on one of the deleted tables. I have tried to refresh the list with the below line of code, but this does not work:
CurrentDb().TableDefs.Refresh
Any ideas how I can force the refresh of the table list
Refreshing table list in Access
ZopoStyle
Found it eventually, I needed to add the below line:
RefreshDatabaseWindow