Unexpected error 40230 when trying to view code

[Supersaurus]

Someone has a left the company and I am having to take on support for an Access 97 system. When trying to view the code in a form, the error "Unexpected error (40230) is shown. The code window is then blank (ie no code!). This also occurs in another form and Module in the same database.

Are these objects corrupted? "Fixing" the database does not work.

 

[BillPower]

This is one I've never heard of, also can't find any info whatsoever on error 40230 at MS.

1. Compact then repair your DB, Tools> Database Utilities>> Compact Database and then Tools> Database Utilities>> Repair Database. Try viewing the code again.

2. Open a form that this doesn't happen on. Open the VBE (view code) from the menu select Debug>> Compile... What happens if anything. Be as descriptive as possible.

3. Create a new DB and import everything from the problem DB into that. Try to view the code again.

Let us know what happens.

Bill

 

[Supersaurus]

Thanks Bill for the advice.

Still no luck I'm afraid.

I've managed to get the corrupted module and 2 forms from a backup.

All seems to be ok now.