Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Push refresh to Access from Sql Server 2000

Author  Topic 

kmac54321
Starting Member

5 Posts

Posted - 2007-09-07 : 13:33:07
I am running a job that runs a stored procedure to update a table in Sql. This job runs once a minute. I am then refreshing the Access form using a timer in Access that also runs once per minute. I would like to be able to send the result table refresh to each client from the job that runs the query on the server. I saw that there was a new feature to SQL2005 called Notification Services that may be what I am looking for. Is there any way to do this in Sql2000?
   

- Advertisement -