3085 - undefined function

[Bill]

We have a MDB used by about 4 or 5 users. They have Office XP over Office
97 where Access 97 was retained and the other apps replaced.

Users frequently get the good ol' 3085 undefined function error. Sometimes
we can resolve this by going into Tools/References and checking/unchecking
(or vice versa) a reference. Other times a simple reboot resolves the
problem.

Suggestions? tia

 

[Douglas J. Steele]

Has the application been split into a front-end (containing the queries,
forms, reports, macros and modules) linked to a back-end (containing only
the tables)? Does each user have his/her own copy of the front-end,
preferably on their hard drive (as opposed to on the server)?

That's the recommended approach to multi-user applications. If you do that,
then you should only have to fix references once if not every user has
exactly the same desktop image.