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.

You can’t upsize Access tables that contain dates earlier than January 1, 1953. Use saved queries as opposed to SQL statements as the data sources for Access objects.