Does anyone know what the maximum limit is for public variables in Access or any other reason why I would get an 'out of memory error' when compiling an application in Access. The app is large and worked until yesterday when some new code was added.....

Thanks in advance


Andrew