decompile question

[Guest]

Hello All,
I've been experiencing db corruption lately, it looks like when i make a
change to a module. I'm running Access 2002 and the db is 2000. I seem to be
able to recover if I replace a module with an older version (but the changes
are still present!?!)
I've seen the suggestions to decompile at first sign of corruption, but do I
need to "RECOMPILE" it once I have decompiled? Does anyone know what this is
doing, is it putting the modules down at a lower version?
I have also added a read-only user (have got 10 full-data users sharing on
LAN) over a WAN recently. Splitting the db sounds a little complex. Is it
inevitable?
Thanks for any insight anyone can share with me!

 

[Paul Overway]

If you haven't split the database, that is why you are experiencing
corruption issues. And if you are attempting to use the database over a WAN
the problem will be even worse. Using an Access database over a WAN is not
recommended. Corruption is inevitable in both of these scenarios.

As for decompile, the following link explains what it does:

http://www.trigeminal.com/usenet/usenet004.asp?1033

 

[Rick Brandt]

Hello All,
I've been experiencing db corruption lately, it looks like when i make a
change to a module. I'm running Access 2002 and the db is 2000. I seem to be
able to recover if I replace a module with an older version (but the changes
are still present!?!)
I've seen the suggestions to decompile at first sign of corruption, but do I
need to "RECOMPILE" it once I have decompiled? Does anyone know what this is
doing, is it putting the modules down at a lower version?
I have also added a read-only user (have got 10 full-data users sharing on
LAN) over a WAN recently. Splitting the db sounds a little complex. Is it
inevitable?
Thanks for any insight anyone can share with me!

If you have a user running over a WAN then that is almost certainly what is
corrupting the file. Even split you normally cannot use Access reliably
over a WAN. There is simply not enough speed for it.

Here is my decompile procedure...

Open Access normally and Compact
Open with Decompile switch, then close
Open Access normally and compact again
Do a compile and save all
Compact again

All of the above on a *copy* of the file. If all goes well I replace the
original with the copy.