Flex Grid Problem

[Ray Milhon]

I have an access 2007 database that was using a MS Flex Grid on 1 form to
display data. After several requests from the users the form was modified to
include a tab control and there were 2 additional Flex Grids added to 2 of
those tabs to display specific data. The original Flex Grid works fine but
the 2 I added work perfect on my PC but do not work on the user's PC. I've
checked both and they both have the same MSFlxgrd.ocx file in the
Windows\System32 directory. Also on the user's PC If I open the properties
window on the 2 flex grids that are not working I have different properties
than if I open the properties on my PC. Anybody have an idea? Thanks for
any assistance

Ray Milhon

 

[Minton M]

I have an access 2007 database that was using a MS Flex Grid on 1 form to
display data.  After several requests from the users the form was modified to
include a tab control and there were 2 additional Flex Grids added to 2 of
those tabs to display specific data.  The original Flex Grid works fine but
the 2 I added work perfect on my PC but do not work on the user's PC. I've
checked both and they both have the same MSFlxgrd.ocx file in the
Windows\System32 directory.  Also on the user's PC If I open the properties
window on the 2 flex grids that are not working I have different properties
than if I open the properties on my PC.  Anybody have an idea?  Thanksfor
any assistance

Ray Milhon

Hi Ray,

This is a licensing problem and plagues FlexGrid on user's machines.
Access never leaves design time (even in runtime) so the Flexgrid
refuses to work because it's not licensed. I'm presuming you have VB6
or Studio installed on your machine so it runs fine on yours but not
theirs.

I've seen this bug manifest itself where some Flexgrid's work but
recently added ones don't. It's a real pain. The legal way to fix this
is to install a legal copy of VB6/Studio on your user's machines. The
illegal way and the one I wouldn't dare advocate is to locate the
registry entry for the license and copy it to your user's machines.
There are newsgroup threads on how to do that but it violates license
policy so I wouldn't dare suggest it.

Hope this helps,
James