I have written an application in which many forms use DAO calls to an Access database. I also have three forms which use ADO to connect to the same db (two are MSHFlexGrids, and the other shows some fields from a table).

My problem is that the application works fine on most PCs, but the primary user of the system cannot see data with the ADO forms. He gets a blank grid which indicates 19 records. He has no problem with the rest of the system - all other DAO database functions work correctly. The file locations are identical between machines, as is the version of Access.

If I try to open the form from the debug window, I get the same situation (blank form with 19 records), but when I view the forms by running the application everything appears as it should be. Any ideas why one person would have a problem?