Re: Access 2003 - use 2000 or 2002/2003 format?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxxxxx> wrote in message
news:EF6516A4-A7D0-49B8-982B-EC02E5CBC043@xxxxxxxxxxxxxxxx
> 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?


.

Relevant Pages

  • Re: Setting field properties in code
    ... References on the Tools menu, ... (BTW, the Format property is a Text type, regardless of the type of field.) ... >> Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (comp.databases.ms-access)
  • Re: I wouldve sworn it was mentioned here
    ... Not necessarily a *specific* genealogy program database, jsut databases in general? ... I'm looking for an easy way to vacuum up "hit" lists from Ancestry. ... Are the hits from all the sources in the same format? ... This requires that you have the hits in a common flat file format or can convert them to that; that hits which you would consider matching are identical within the files; that you either don't care which lists the matches were in, don't mind just comparing them in pairs or are prepared to hunt for them in the files and finally that you have access to Unix-style commands. ...
    (soc.genealogy.computing)
  • Re: I wouldve sworn it was mentioned here
    ... compare databases and flag matches? ... Not necessarily a *specific* genealogy program database, jsut databases in general? ... Are the hits from all the sources in the same format? ... This requires that you have the hits in a common flat file format or can convert them to that; that hits which you would consider matching are identical within the files; that you either don't care which lists the matches were in, don't mind just comparing them in pairs or are prepared to hunt for them in the files and finally that you have access to Unix-style commands. ...
    (soc.genealogy.computing)
  • Re: Lebans Calendar Question
    ... I developed a simple databases for production reporting at our manufacturing ... I changed my short date format through my ... and it was reflected prpoerly in the Calendar window. ...
    (microsoft.public.access.forms)
  • Re: Advice on desktop search engine
    ... Windows desktop does. ... Unfortunately, Copernic does not do databases, in any format. ... desktop search programs. ...
    (sci.lang.translation)