I'm confused about how to link my app to an Access database - there seems to be a number of approaches.
I can add in my database via the Data Sources tab. Fine if I want to bind controls and view/edit data. But is this the best approach for queries that return an answer that is a different shape to the original table?
Alternatively I can connect to the database directly (connection string, etc) and run sql queries.
What are advantages/disadvantages of each approach? In terms of flexibility, is the second approach best? Also, does the second approach require the database to be added via the Data Sources tab?