By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,105 Members | 2,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,105 IT Pros & Developers. It's quick & easy.

Access Project Refresh connection to SQL Server 2000

P: n/a
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"

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

tbl = "temp_tbl_master"
DoCmd.DeleteObject acTable, tbl

Set rs = cmd.Execute

End Function
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.