Code Corruption Problem

[Howard Brody]

See comments below:

-----Original Message-----
I have a couple of ideas to help:

1) open a module in the vba editor and click on
tools\referances. If you are missing a referance then
uncheck the one that is labeled "missing" and close and
save. This would be the temporary fix. The cause of this
problem: if you have a multi user enviornment then some
machines may not have the correct .dll or .ocx files that
the database was created to use. Update the computers
with the correct files and that will solve that problem.

1) None of the references are labeled "Missing" and while
I am in a multi-user environment, I've had two databases
go bad during development - before they've been on any PC
other than mine.

2) Open a module in the vba editor and click on the
toolbar: Debug\CompileCurrentProject. This will compile
all the modules and let you know what it doesn't like. I
once named a procedure the same as an existing procedure.
It took me a very long time to figure this out.

i would be curious to know if this helped. Feel free to
email me.
Trace

2) It doesn't want to let me compile. I get a "File not
found. Network connection may be lost." error message,
even when working on a PC not connected to the company
network or server.

I apreciate the help and the ideas.

Thanks!

Howard