Hello Frank
if you use SQL 2000 or 2005 you can use notfication services to acomplish
this ( great new feature ) for sql 2000 this is a ( free ) adon you need
to install to get this working SQL 2005 has this functionality standard
onboard ... the database performs then a callback to your app when the
subscribed dataset changes
search on MSDN for notification services
regards
Michel Posseth [MCP]
"Frank" <Fr***@discussions.microsoft.com> wrote in message
news:AC**********************************@microsof t.com...
I have an application that is used by multiple people. They all see the
same
table contents from a sql-db. If a user adds/changes or removes a record
the
other users must refresh there dataset manually to see the changes. How
can I
make my application aware of db-changes automaticly so that the users
don't
have to manually refresh the screen.
Thanks,
Frank