Corruption of Access File

[Samuel]

Hi

I think that since my client and myself don't have the same version of
Access the file gets corrupted when I get the latest version from my client
(they have Access 2000 and I have Access 2003)

What can be done?

Thank you,
Samuel

 

[Allen Browne]

Perform this sequence when you get the updated file:
Compact | Decompile | Compact | Compact | Compile

To compact:
Tools | Database Utilities | Compact/Repair

To decompile, enter something like this at the command prompt while Access
is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

To compile, open the code window and choose Compile on the Debug menu.

If the database has startup code, hold down the Shift key during each
operation so that Access doesn't automatically compile and run the code.

Explanation:
========
Each version of Access has a different binary (compiled version of the
code.) Theoretically, it should transparently recompile into its own binary
from the text version of the code, but this process is not perfect. The
decompile instructs Access to discard the binary, which is then recreated by
the compile.

It may also help to open Tools | Options (in the code window), and uncheck
the box for Compile On Demand.

 

[Samuel]

Thank you for your time

Samuel

Perform this sequence when you get the updated file:
Compact | Decompile | Compact | Compact | Compile

To compact:
Tools | Database Utilities | Compact/Repair

To decompile, enter something like this at the command prompt while Access
is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

To compile, open the code window and choose Compile on the Debug menu.

If the database has startup code, hold down the Shift key during each
operation so that Access doesn't automatically compile and run the code.

Explanation:
========
Each version of Access has a different binary (compiled version of the
code.) Theoretically, it should transparently recompile into its own
binary from the text version of the code, but this process is not perfect.
The decompile instructs Access to discard the binary, which is then
recreated by the compile.

It may also help to open Tools | Options (in the code window), and uncheck
the box for Compile On Demand.