Runtime memory error 1

[paulfenwick]

Hi, I have a 'typical' access database in FE/BE style with some basic VBA coding for form buttons and a few precedures and functions in a module called Public_functions.

I have (obviosuly) made many changes in the code over the development phase without any issues. Now I want to add a few lines of comment to the module public_functions and when I do this and save / recompile it saves OK but on opening the database, I get the folowing message:

'The instruction at "0x6517daaa" referenced memory at "0x00000023". The memory could not be "read".'

Even just putting a new empty line in the code, saving and opening has the same effect.

I have tried reparing and compacting the database but i still get the same error on opening the database.

Any suggestions would be helpfull - thanks

note: I can edit the code in one of the form modules OK - it only seems to be this module

 

[Remou]

Have you tried a decompile?

http://www.granite.ab.ca/access/decompile.htm

If that does not work, and it should, the best bet is to import everything into a new database.

http://lessthandot.com

 

[paulfenwick]

Thanks Remou

That worked great!

(Didnt decrease the filesize as I read about on a few posts after your tip - but it worked and that thats all I needed!!)

 

[Remou]

I have found decompile, followed by compact and repair works best for decreasing file size.

http://lessthandot.com