Datagrid not displaying data

[marksparky]

Hi,

I have added a Datagrid to a simple quote tracking app that I developed to list current quotes. The exe sits on a shared drive that 4 users can access. Two people (including myself) can run the app and see all the current quotes listed in the datagrid. The other 2 users get a blank datagrid.

- We all use Windows XP Pro.
- The app was developed using VB6.
- The DataEnvironment (db name - QuoteDb) points to a small Access Db located on the shared drive.
- COMDLG32.OCX and MSDATGRD.OCX both reside in the shared directory.

Why would the datagrid display data for some and not the others when we all access the same exe from the LAN?

Any help is much appreciated.

Cheers
Mark

 

[vbrocks]

Does the data appear on their screens when only they access the database?

 

[gusset]

could it be a problem related to the version of ado running on the other machinrs?

 

[marksparky]

No. There is no data on their screen when viewing the datagrid. However, I have an automated Quote Number that appears whenever a new quote is entered and the quote number does appear. So they do have connectivity.

I will have to check what version of ado they're running.

I added a save function that sends the data to a text file so I could check if the data is there. I then asked a user (who cant see the data in the datagrid) to save the data. I then checked the text file and all the data is there. I can only assume then that its got something to do with the displaying of data in the datagrid for these affected users.

Thanks so far.

 

[SRobertsBDS]

Hi marksparky, have you solved this problem as I have exactly the same thing happening to me and it's driving me nuts !

 

[CCLINT]

If the code is not identical, or user set application options are different, then I would guess that the problem is that you are not using a client cursor as the CursorLocation, or it is erroing out somewhere are the grid's datasource is not getting set.

Do you see blank lines where the data should be, or grey?

Make sure you have upgraded to VB6 SP5 and have distributd your application using a setup installation program to make sure all components (DE) have the correct version.

I doubt if the problem is an ADO version as MDAC 2.5 is installed by default. But, who knows if something else messed things up....

 

[Spellman]

Hi Mark,

I remember having a similar problem before in that on one screen a label was showing data but on another it wasn't. The problem on that one had to do with the Windows display settings for some reason. You could try making sure that all machines have the same windows display settings just to be on the safe side. Hope this helps a little.

Mark

The key to immortality is to make a big impression in this life!!

 

[CCLINT]

That was one of my thoughts also, and why I asked "Do you see blank lines..." (the foreground color could be set also in code to that of the bachgroung color)

But I understand from:

> "I have an automated Quote Number that appears whenever a new quote is entered and the quote number does appear"

that text does appear under this given situation.

 

[vbrocks]

Have you checked the user permission settings for the users on those nodes? An easy thing to check is to have them log on a working computer and see if they have access.