Errors appear on different variables, Option explicit stands in all modules. I change the name of a variable in the declaration, change it in the function — it works, I return the old name — it works, but an error appears on another variable.

Error example

What can be wrong ?

  • one
    error on the second underlined line - mdli
  • one
    there is a function called from another function in the same module, now it says that it is not defined. What are these problems? - mdli
  • one
    Looks like base damage. Copy everything into a new database - Sergey S.
  • squeezed the base and the error disappeared - mdli

1 answer 1

  1. Squeeze the base (well, you've already done this)
  2. Decompile database: >msaccess.exe your.mdb /decompile
  3. Squeeze again.
  4. Save for the future in a dark cool place. .