Use saved queries as opposed to SQL statements as the data sources for Access objects. The wizard will create a corresponding ... least one unique constraint or index to every table.

By querying these dynamic management views using a query similar to the one shown below you can see all of the indexes which the SQL Server recommends creating. Do NOT simply create these indexes.

BR><BR>So - here is what I'd like to do:<BR><BR>1. 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 ...

Use SQL to quickly create a new table from existing records in Access Your email has been sent SQL lets you use one command to quickly create a new table containing a subset of records from a ...