Bar Chart Issue

[irish634]

I'm not sure if this belongs here or in the "Reports" section, so my apologies if I selected wrong.

I have a weird issue that I cannot seem to put my finger on.

I have a multi-user application (each user has their own FE and the BE is on the network. I have created a simple bar chart (MSGraph.Chart.8 - Since I'm stuck in the stone ages of Access 2000). It runs off a really simple query and the only criteria is "Date()-365" which shows me only data for the last year.

The weird issue is: This chart displays on every PC except 2. All PC's have the same FE copy. All except the 2 pcs show the chart correctly. The 2 that don't only display the border of the chart, nothing else.

I am assuming this is something simple that I am over looking, but what am I missing here?

 

[Fifty2One]

Check how the two machines are set up for memory and also for security. We had some machines which would also have troubles with smmoothly loading continuous form data - some for security settings and others by the way the ram and cache memory is allocated.
If you minimuze then mazimize the chart on the screen on the 'bad' machines does the chart populate? If not then it is likely the security setting - if it does then it is memory allocation.

 

[AJordan]

I have had a similar issue with Access 2007, however, I went with the theory that the computer was old/not updated with the latest windows updates. I did realize that if I hit refresh (F5) the graph would show on that computer.

 

[irish634]

Well as far as security, all pcs have the same access and rights.

I thought about the theory of different versions. Looking into it further, one pc has Access 2000 SP3 (exactly what I have as developer) and the other pc has Access 2000 with no service packs. Both exhibit the same problem.

Refreshing the view or minimizing and maximizing as suggested makes no difference.

One thing I did notice: On the pcs that have the problem, they don't seem to recognize the "Format([MyField],"xxxxx") function. So I believe I have a missing reference?

If so, how to I make sure an MDE file has the right references on these pcs?

 

[ChrisO]

>>If so, how to I make sure an MDE file has the right references on these pcs?<<

I think the real answer to that question is to remove all references and late bind everything.
You will then have to re-issue a new FE to all users.

 

[irish634]

Updating the front end isn't really a big deal because I use Bobs FE updater so I'll give that a go too.

This is a frustrating problem that will undoubtedly have a simple answer

 

[ChrisO]

It’s hard to predict which references might break on which machines so I think it’s simply better to get rid of them.