ADP doesn't refresh after Alter Table command

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Geri Reshef - 23 Nov 2004 19:43 GMT

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?

Reply to this Message

Mary Chipman - 26 Nov 2004 19:38 GMT

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

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

Reply to this Message

andi - 27 Nov 2004 03:15 GMT

Hi,
add RefreshDatabaseWindow method after the alter table codes.

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

Reply to this Message