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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top