First of all I would like to thank you for your suggestions. I tried using the "Use Low Compatibility Mode" but sadly enough that doesn't fix my problem.
When I connect to my data source using the exact same ODBC-driver in Excel, I get the data that I'm looking for. Where do I go from here? Should I get all the data to Excel using the ODCB-driver and then connect to this Excel file using the Jet Data Manager or is there another option?
JetEnterprise can't read all data from datasource