If anyone can help me with this they will deserve 50000 points not just 500.
We have a database application written in Delphi which has been working well for many years under Win 2000, XP, Vista and 7.
The application is described fully here: www.rcmdesktop.com
, with basic technical information here TechnicalInformationForITDepartments
We connect to the ODBC database driver with a TADOConnection and the OLE DB Provider is Microsoft OLE DB Provider for ODBC Drivers (MSDASQL.1).
We use TADODataset->TDatasetProvi
ce for all datasets and the vast majority of bound controls are DevExpress grids and editors.
Last week was the first time a user installed it onto Windows 8. Things seemed OK until they attempted to open a table with more than 32 records. At that point the application hangs.
We have done some testing on a brand new Win 8 laptop - any table with more than 32 records in any of the many databases we have causes the application to freeze - so we have ruled out data corruption as the cause.
Database utilities, and even a small test app we wrote, can all read & write to tables with >32 records, so we don't think it is the database engine (Mimer SQL 9.2).
We have spent a couple of days trying to fix this but got nowhere.
Can anyone suggest where we might start looking for the cause of this very strange behaviour?