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?
Many thanks