Can anyone help. I have a large Access app (32MB) that uses Map Objects 2.2. If I add more lines of code, when I compile the app and then save it, I cannot get back into my vba code. (when I press the code button, the app just hangs) This has happened in 2 different apps. I have reimported all the forms/reports etc into a new app and this does not help either. Is there a limit on the number of lines of vba code that you have in a .mdb file?
Sounds weird, the file isn't that large that it should cause this problem; some of mine run to 500MB.
I'd try repairing your Office software if that options available, and if not, re-install. ALT+F11 also brings up the code window so I'd be curious if that makes any diff (can't imagine it will!) and I'd also try CTRL+Break to see if that stops the hang and lets you into the code window.
I have tried Alt+ F11 and Ctrl+Break - neither helps. I am working in Access 2000. There is no data in my app as all my data is stored in linked SQL tables. Somehow this is linked to my use of MapObjects. My form that displays the map has 3078 lines of code. I also have a lot of code in my modules. This is the biggest form in the app. This is the second time that this has happened to me, but both apps use Map Objects. I do have apps that are greater than 60MB that have been around for 3 years and have not done this. (they don't use MapObjects). I only get blocked out of the vba code after I have done a successful compile. The application still runs perfectly, so obviously the code must still be there, but is not letting me get at it. I managed to get around this problem last time, but creating a new app and importing all the forms/reports etc from a backup of the corrupted app. After the compile, everything seemed OK, but this time this does not work. Any other suggestions