ADP doesn't refresh after Alter Table command

[Geri Reshef]

After sending an Alter Table commnd (e.g. MyProject.Connection.Exec "Alter Table ... Drop Column ..") the table doesn't change unless I shutdown and re-open the project.
How can I refresh it?

 

[Mary Chipman]

Shut down and reopen, or write code to disconnect-reconnect. Access
cashes the schema for existing objects when it connects to SQL Server,
not continuously. So if you make schema changes while the project is
open, you won't see them until you shut down and reopen. FWIW, you're
better off using Enterprise Manager or QA to create SQLS objects. Just
use ADPs for deployment.

--Mary

 

[andi]

Hi,
add RefreshDatabaseWindow method after the alter table codes.