Is there a way to open an SQL statement in Access Project (2003) in VBA code? Basically, I'm looking to temporarily create an SQL statement and then open it, normally to get the typical spreadsheet-like display of the result. This would be defining a pass through SQL query in regular Access that is linked to a SQL Server database and then opening that pass through query, and then deleting the pass through query.
Bob
Bob