Hello,

I'm running an Access .adp front end with an sql7 back end, I'm running stored procedures from code in Access, these procedures are creating tables on the SQL server. These tables are then used for further operations. The problem is that when the StoredProc executes and creates the table X, access cannot see or make reference to table X until I manually hit F5 over the database window to refresh the list of tables. Does anyone know a way to do this automatically?, application.refreshdatabasewindow doesn't work, I can call that nothing appears, then press F5 and they all appear. The same thing is happening when I delete a table, it remains visible and accessable until I press F5.

Please help,

John