Do you mean that you have a link to a view in an SQL Server database
somewhere? If so, you could have a procedure that kicks off according to a
schedule. But as far as having the external data source inform the Access
database of a change - don't know if that's possible or not...

"meangene" wrote:

I have a table that populates specific data from a SQL view when I manually
run an append query - works fine.

What I really need to do is have that table populated automatically the
moment a new record appears in the view - hands-off on my part. How could I
best do this?