Refresh my connection

[laprog]

Hi,
Application (Access project) - Database (SQL Server)

I execute a procedure that drops a table completely.
CurrentProject.Connection.Execute ("drop table dbo.logbookDbase")

Now if i look at my list of SQL-Server tables through my access table list, the table still show even though i
dropped it. I want it to disappear.

I need to press on F5, in order to make it disapear.
Is there a way, by code, i can make this table disappear by
refreshing my connection?

Please let me know, we've been looking and are not able to find a solution.

Thank you!

laprog

 

[laprog]

Hi everyone

Do not bother instead of dropping my table by executing my instruction on the SQL side, i dropped it using VBA which then resulted in making my table disappear right away.

Here is the code i used:
DoCmd.DeleteObject acTable, "logbookDbase"
insead of
CurrentProject.Connection.Execute ("drop table dbo.logbookDbase")

Thanks anyway! Have a nice weekend!laprog