Access Project Refresh connection to SQL Server 2000

[Bob Davies]

I have an SQL Server database which I have upsized from Access. I have
written a Procedure in SQL Server which creates a new table based on
joining several other tables.

However, Access Project is unable to see this table untill I view the
table list and hit F5. Is there a way to do this programatically
within the vba code.

Public Function fnc_test()
Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rs As New ADODB.Recordset
Set db = CurrentDb

cn.Provider = "sqloledb"
cn.Properties("Data Source").Value = "(Local)"
cn.Properties("Initial Catalog").Value = "GDLSQL"
cn.Properties("Integrated Security").Value = "SSPI"
cn.Open

cmd.ActiveConnection = cn
cmd.CommandText = "fnc_master"
cmd.CommandType = adCmdStoredProc

tbl = "temp_tbl_master"
DoCmd.DeleteObject acTable, tbl

Set rs = cmd.Execute

End Function