BCain
September 14th, 2001, 12:58 PM
I have a problem with using VB in a Microsoft Project(connected to SQL server 7.0) and need help please ;)
I am programmatically creating a table on the SQL server using DoCmd.RunSQL "SELECT .... INTO ... FROM ..." and later in the method I need to delete the table I created, however it cannot find the table! I have tried RefreshDatabaseWindow in many different forms, and even tried sending a 'F5' key to the app, but nothing works. The only way I can get it to work is by breaking before the delete command and manually hitting F5 on the database window and the table is shown. Then I can delete it programmatically.
Is there another way of doing it that I can accomplish my goal? Why is RefreshDatabaseWindow not working but F5 does?
Failing this, is there any way to use the SendObject method with a serverview? It can be used with the action, but I need to automate this.
Thanks for any help,
Brian
I am programmatically creating a table on the SQL server using DoCmd.RunSQL "SELECT .... INTO ... FROM ..." and later in the method I need to delete the table I created, however it cannot find the table! I have tried RefreshDatabaseWindow in many different forms, and even tried sending a 'F5' key to the app, but nothing works. The only way I can get it to work is by breaking before the delete command and manually hitting F5 on the database window and the table is shown. Then I can delete it programmatically.
Is there another way of doing it that I can accomplish my goal? Why is RefreshDatabaseWindow not working but F5 does?
Failing this, is there any way to use the SendObject method with a serverview? It can be used with the action, but I need to automate this.
Thanks for any help,
Brian