Using V10 SR 5 and trying to read an Access 97 Database, which has workgroup permissions. Forcing 32 bit OLE DB to get at the Jet 4 OLEDB or ACE OLEDB (same issue with both) and can get a successful Test Connection. I can then Select a table and even preview the data.
The problem comes when I try and Reload the data, it fails’ to connect to the database and a screen below appears. Entering the username and password again has no affect.