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.

Make life easier for your Access users by building a parameter query that lets them search for specific text. Instead of fumbling around with wildcard characters, they can just enter the search ...

You can query across databases in Oracle and Sql Server, with a little work. I'm not sure about access. <BR>It really would be easier to just link the tables I would think. Probably give better ...

display all Access operations. You can create queries, forms, and reports, and add or delete data to the Excel table—just as you could do if you had imported it as an Access table.

How to Repeat Columns in Access. When you have to scroll to the right to view all of the data on a wide Access query or report, you might want to repeat one or more columns that contain the ...