Jet on MS access 2003?
there is a databse someone made in the company. when users try to get a report by click on a box in a form, it give them the error below. i would think it's a problem with the database but not all users have the same experience. there is actually a user who can open the report with no problem from his PC but not from other machines. so i suspect that it's some settings in ms Access?
can anyone please help me with this?
Visual Basic for Applications (VBA) encountered a problem while attempting to access a property or method. The problem may be one of the following:
A reference is missing.
For help restoring missing references, see the Microsoft Knowledge Base article 283806.
An Expression is misspelled.
Check all expressions used in event properties for correct spelling.
A user-defined function is declared as a sub or as a private function in a module.
Expressions can resolve a user-defined function only if the function is declared as one of the following:
A public function in a module
A public or private function in a code module of the current form or report
Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8 update is not installed.
A more recent verion of Jet 4.0 must be installed for Access to function properly when security is set to Medium or High. To obtain the latest version of Microsoft Jet, go to Windows Update.