Access 2007 VBA Linked Tables to SQL Server - ADODB Read/Write - I just need a few lines of code

I have written a tool tha moves data between several systems. DAO doesn't want to work with one of these systems from VBA. I've played with it for several days. I need t to work fast. So i need some help. I'm pretty sure i'm doing one or more stupid things so i assume it wiull only a be a couple of hours at most for the right resource. Cheers. Detail spec: 1. VBA Function called with the primary key value in the Linked SQL Server DB. 2. Open connection and Seek Read of the single row 3. Return the "Item Description" as the function value or "" on error. d