ADP doesn't refresh after Alter Table command

  • Thread starter Thread starter Geri Reshef
  • Start date Start date
G

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?
 
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
 
Back
Top