ADP doesn't refresh after Alter Table command

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?
 
M

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
 
Top