Corruption of Access File

S

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
 
A

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.
 
S

Samuel

Thank you for your time

Samuel

Allen Browne said:
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.
Click to expand...
 
Top