refreshing tables with code

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

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