Unlike SQL Server, Access also offers a variety of development ... and Visual Basic for Applications (VBA) code modules. All the other objects—the tables, stored procedures, views, and so ...

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.

Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which ...