Select each table you want to copy from the SQL Server database to your Access database. Choose "OK" to start the import and then "Close" when the import is complete.

Microsoft (MS) Access and SQL are different database applications with pros and cons. But, instead of choosing between them, you can, as it turns out, make them work together.

When a Recordset object is created, the Microsoft Jet database engine uses the table's field name as the Field object name in the Recordset object. If you want a different field name or a name is not ...

If Access cannot run the entire query on SQL Server, it will run as much as possible on it, and when it retrieves the results set from SQL Server, it will then complete the query locally.