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 ...

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it.

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 ...