refreshing tables with code

[Roy Goldhammer]

Hello there

i have access 2003 adp.

one of my store procedures that i run create new table.

I need in the code that runs the store procedure to refresh the list of
tables in the adp so i can use these tables afterword.

on mdb i had: currentDb.tableDefs.refresh

is there another action that looks like this on adp?

 

[Roy Goldhammer]

To whom will be consern

here is code i found out that do it:

Sub RefreshConnection()
Dim str As String

With Access.CurrentProject
str = .BaseConnectionString
.CloseConnection
.OpenConnection str
End With

End Sub