FlexGrid Problem

[Glen_Kruse]

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?

[Ianpbaker]

Are you using a DSN connection ?

If yes have you set up the DSN on that computer because normally if everybody can see it apart from one person it normally means the dsn isn't on that computer or is not correct.

Hope this helps

Ian