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.

Learn how to add and remove Primary Keys from an Access database table. The primary key's purpose is to promptly associate data from multiple tables and combine that data.