It is also useful if you are running SQL statements from an SQL application in another SQL-based database. ... If you want to continually access the most current data, create a view from the query ...

Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.