refreshing objects

R

Roy Goldhammer

Hello there

I have access 2003 adp that connect to sql server

I add new table/view/store procedure on sql server and in order to see it on
access i must refresh adp manually.

Is there a way to refresh access by code?
 
G

Graham R Seach

Roy,

Try Application.RefreshDatabaseWindow

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
refreshing tables with code 1
How to refresh (programmatically) an ADP project's knowledge about views and stored procedures? 16
What's the steps to modify a .adp connect string & convert DAO to 2
Access 2000 ADP and SQL Server 2005 2
function sort order 3
Future of ADP - new article 12
ADP and SQL 2005 2

Top