Runtime error 2467 for some users and not for others

[Doug Goodenough]

..Hello,

I maintain an Access application that is used by internal users and by a
company external to mine. We are both running access 2003. When I gave
the application to the external company to test prior to rolling it out into
production they are getting runtime error 2467 when trying to access the main
form of the application. My internal users are not encountering this issue.
The application version is the same for both users. I have tried having
the external users refresh the linked tables to the sql server db as well as
re-compling the modules with no luck. The external users are on this
version 11.5614.6568 while the internal users are on 11.6566.8132 SP2.

Could the different versions be the problem?

Thx!
Doug

 

[John W. Vinson]

Could the different versions be the problem?

Yes.

Try decompiling, compacting, compiling and again compacting on the user's
machine.

A2000 was VERY buggy in its initial releases - you should certainly apply all
the service packs, or - preferably - upgrade to 2003, which is much more
stable. It uses 2000 format for its databases so you're not losing anything.

John W. Vinson [MVP]

 

['69 Camaro]

Hi, Doug.

I have tried having
the external users refresh the linked tables to the sql server db as well
as
re-compling the modules with no luck.

Have one of the users step through the code and tell you which line of code
bombs so that you can determine which object is either closed or doesn't
exist, and then go from there to determine _why_ it's closed (Didn't that
object open when it was supposed to? Why not?) or doesn't exist on their
workstations. Suspect that any non-standard libraries are in different
locations on their workstations from your own when you troubleshoot.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.