I've been googling for a day straight now, and am no closer to my goal.
My intention is to set up a data view web part that reads from an access database (accdb or mdb; it doesn't matter to me) that can be filtered by the user. I've gotten to the point where I specifiy the connection string, and have done my best to piece it together as best I can from connectionstrings.com and MS resources. It then tells me that my password will be sent in plain text (no big deal). I click okay, then it tells me I have an error in my connection string, which says, "Server Error: An error occurred while retrieving the list of Tables from the root Database: The query you are trying to execute contains syntax errors." It then takes me to the next screen where it has a dropdown list of databases, which includes only "root", a list of tables from the selected database (there are none listed for me), and an option to specify a custom SQL query. Since you cannot click "Finish" without selecting a table or custom query, I create a custom query, click OK, and do "View Data" on my new datasource. The usual "Rows" at the top of the list shows, but no data.
I'm not sure where to go from here. I have tried taking the automatically added "Initial Catalog:root" line out of the xml file with no avail.
Other useful information: this must be a WSS 3.0 solution and my Access DB has linked tables in it.
Thanks in advance,
-gb