Conversion issues between Acc2k and Acc2003?

[Guest]

Can anyone point me to a good resource to show me what potential problems I'll have converting from Access 2000 to Access 2003? I understand that 2003 can read and work with the 2000 files, but that 2003 has a different native format? I'd just like to get a good idea of the different issues that might come up.

Thanks for any guidance,

E

 

[Allen Browne]

The default install of A2003 sets up to use the A2000 file format, and many
of us continue to use that, mostly for backward compatibility. You will need
to convert to A2002/3 format to create an MDE, but the conversion is very
simple.

Most of the bugs in A2000 are still there in 2003, such as the Name
AutoCorrect problems, filter problems, faulty Decimal data type, and so on.
Details:
http://allenbrowne.com/tips.html#flaws

There are also some new bugs. For example, wherever you use a subform in
A2002 or A2003 (regardless of file format), add a text box to the subform
for the field(s) named in LinkChildFields. Failure to do that can cause
Access to crash.

 

[Elwood]

Thanks,

E