HappyCoding
New member
- Local time
- Today, 20:20
- Joined
- Feb 25, 2023
- Messages
- 20
As the Title suggests, I am experiencing strange things in the VBA Editor of Access 2007.
I am looking for an explanation and of course a solution to the problems.
Example 1
If I type something like this, in code that would normally compile just fine
Dim aString As String
After enter, it will be changed to this
Dim me() as String
Which of course does not compile anymore.
Sometimes "decompile and Compress" will solve the problem and new declarations are possible.
Example 2
Typing multiple Lines in a Sub or Function of code gives no problems
But compiling throws Compile Errors in some random other Modules or Forms, that without this change would compile without problems.
Sometimes the message is just: - not enough memory
Decompiling and compressing will not solve the Problem
Solution to both examples
Deleting a different Form, sometimes one, sometimes more, solves the Problem.
The code that previously could not be compiled or would be changed by Access, will, without any changes, compile without problems
Presuming that if compiling completes normal, there would not be any Syntax Errors.
It is a large Project with many Forms, Reports, Classes and Modules, but the known limits to Access are not reached yet; Object count, module sizes etc.
Are there any other Limits in Access I can check?
It seems like there is a limit on the number of total Variables in a Project.
Or maybe a limit on String Space.
I tried importing the project in Access 2010, same Problems.
Importing all objects in a new Project does not solve the problems.
The Project should stay at Access 2007, so upgrading to Access 2016 or 2019 is not an Option
Any suggestions are welcome.
Thanks
I am looking for an explanation and of course a solution to the problems.
Example 1
If I type something like this, in code that would normally compile just fine
Dim aString As String
After enter, it will be changed to this
Dim me() as String
Which of course does not compile anymore.
Sometimes "decompile and Compress" will solve the problem and new declarations are possible.
Example 2
Typing multiple Lines in a Sub or Function of code gives no problems
But compiling throws Compile Errors in some random other Modules or Forms, that without this change would compile without problems.
Sometimes the message is just: - not enough memory
Decompiling and compressing will not solve the Problem
Solution to both examples
Deleting a different Form, sometimes one, sometimes more, solves the Problem.
The code that previously could not be compiled or would be changed by Access, will, without any changes, compile without problems
Presuming that if compiling completes normal, there would not be any Syntax Errors.
It is a large Project with many Forms, Reports, Classes and Modules, but the known limits to Access are not reached yet; Object count, module sizes etc.
Are there any other Limits in Access I can check?
It seems like there is a limit on the number of total Variables in a Project.
Or maybe a limit on String Space.
I tried importing the project in Access 2010, same Problems.
Importing all objects in a new Project does not solve the problems.
The Project should stay at Access 2007, so upgrading to Access 2016 or 2019 is not an Option
Any suggestions are welcome.
Thanks
