MS Access data conversion - Access 2003 - use 2000 or 2002/2003 format?

Author

Access 2003 - use 2000 or 2002/2003 format?

mscertified

2005-12-13, 8:26 pm

We just went through a huge Access 97 to 2003 upgrade (1500+ mdb files). We
did this only for Access 97 databases; we left any Access 2000 databases
alone. We now therefore have a mix of Access databases in 2000 format and
2002/2003 format. What advantages (if any) does the 2002/2003 format offer?
Now that everyone has Office 2003 should we change the default format of
Access from 2000 to 2002/2003 so any new databases are created in that format?

Allen Browne

2005-12-13, 8:26 pm

There is very little practical difference, other than you must use the
2002/2003 format to generate an MDE from 2003.

Details:
http://allenbrowne.com/ser-48.html#formats

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

"mscertified" <rupert@tigerlily.com> wrote in message
news:EF6516A4-A7D0-49B8-982B- EC02E5CBC043@microso
ft.com...
> We just went through a huge Access 97 to 2003 upgrade (1500+ mdb files).
> We
> did this only for Access 97 databases; we left any Access 2000 databases
> alone. We now therefore have a mix of Access databases in 2000 format and
> 2002/2003 format. What advantages (if any) does the 2002/2003 format
> offer?
> Now that everyone has Office 2003 should we change the default format of
> Access from 2000 to 2002/2003 so any new databases are created in that
> format?

Sponsored Links