Access Project and VBA

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