Problem deploying MSHFLXGD in MSAccess 2003 runtime
Posted on 2009-04-16
I am developing an Access 2003 application which uses the MSHFLXGD control and is to be run using the MSaccess 2003 runtime.
On my target machine, having installed the runtime and registered the OCX, when the application starts up it gets an error 438 - Object doesn't support this property or method.
It would appear that this is when it's doing a .move of the control.
The application shows no problems in the development environment and I've tried it with the runtime on various test machines and it is NOW running fine on all of them.
At one time it was getting the same problem on a test machine and eventually I discovered that it was because it was trying to use an installed Access2000 development version rather than the 2003 runtime, however this was fixed when I set up the correct shortcut path.
The only thing that's particularly different on the problem machine is that it's got Office 2002 XP Business edition installed (or whatever it's correctly called!) but that contains no Access database and I've got the correct shortcuts set up anyway.
I believe (from my tests) that Access 2000 (and possibly Access 2002) did not support the .move method for this control (or maybe for any control?), though 2003 does which, if I'm correct, suggests that it's trying to run in the wrong environment!
I've tried reinstalling the 2003 runtime but nothing I try makes any difference.
I've pretty well run out of ideas of even what tests I can run now so I'm hoping that someone else has come across this problem and can point me in the right direction.