Hi.
not sure what if any problems are common.
Folks commonly try to share the database file without splitting it into a
front end and back end. This often causes corruption, especially when a
developer is making changes to the database file when other users have the
file open. This is prevented in Access 2000 and later versions with an error
message that exclusive access is needed to save the object, but Access 97
happily saves -- or tries to, with corruption being the likely result. So if
you're used to making changes in a shared database, don't.
Turn off Track Name AutoCorrect info (common cause of corruption), remove
subdatasheets from related tables (performance dragger), turn on "Require
Variable Declaration" (easier bug detection) and turn off "Compile On Demand"
(less common cause of corruption) in the VB Editor. And don't let anyone
open the Access 2003 database file with Access 2000 _unless_ they also have
Microsoft Office 2000 SP-3 installed (causes unrecoverable code corruption
due to incompatible VBE libraries).
My only
concern is that the file size in 97 is 6.78 MB, and in 2003 it's 2.06 MB. Is
there a simple explanation?
This is most likely due to the Access 97 file not being compacted. Compact
it and it will likely shrink to a similar size compared to the Access 2003
file. Expect the compacted Access 97 file to be "a little smaller" than the
compacted Access 2003 file.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.