If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conversion issues between Acc2k and Acc2003?
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 |
#2
|
|||
|
|||
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. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. wrote in message m... 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. |
#3
|
|||
|
|||
Thanks,
E On Thu, 5 May 2005 22:58:43 +0800, "Allen Browne" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|