Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats. There is no connection type specific to Microsoft SQL ...
on "rebuild from source" on my own access-accdb I get an error on importing a special query. In my project I have 1100 queries, and only two queries which uses "UNION ...