A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Conversion issues between Acc2k and Acc2003?



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2005, 02:41 PM
external usenet poster
 
Posts: n/a
Default 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  
Old May 5th, 2005, 03:58 PM
Allen Browne
external usenet poster
 
Posts: n/a
Default

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  
Old May 5th, 2005, 04:32 PM
Elwood
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.