A
Angus
I have just installed my app on a new PC with a new installation of Access
2003. All Windows Update and Office Update is done.
When I launch the app I get a message saying that it is opening as 'Read
Only' and when I run certain procedures I get the following error message:
*********
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.
**********
The code works fine on some other PCs so I presume the last part about the
security relates to me. How do I change the security level to low? The
Macro security is already set at low.
Thanks in advance.
2003. All Windows Update and Office Update is done.
When I launch the app I get a message saying that it is opening as 'Read
Only' and when I run certain procedures I get the following error message:
*********
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.
**********
The code works fine on some other PCs so I presume the last part about the
security relates to me. How do I change the security level to low? The
Macro security is already set at low.
Thanks in advance.