I can understand this if you use code to create a table (there is a refresh method for TableDefs and DatabaseWindow) but not if linking or importing. Suggest you backup copy db and go Run dialog and
- msaccess.exe /decompile "C:\FolePathToYourDB\NameOfYourDB.mdb"
-compact/repair
-close and reopen
- go to VB Editor and Debug -> Compile
If any errors appear, fix them and recompile.
- Close vbe
- CR again
You might get a refreshed view via playing with nav pane groups but I don't think you should have to.
Last edited by Micron; 06-26-2019 at 02:35 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.