Which file format

[ted medin]

We have been running office xp for some time & see that our file format is
2000. Since xp can also do 2002 should we switch to 2002 file format?
Perhaps there is a faq that explains the differences ... . TIA

 

[Pat Hartman\(MVP\)]

If you don't have to worry about users with older versions of Access, it
would be better to use the 2002/2003 file format.

 

[ted medin]

Is there a link that explains the differences? TIA

 

[Pat Hartman\(MVP\)]

You should be able to find an item in help that tells you the differences
between the current version of Access and the previous version. It will not
go into any specifics regarding file format differences. It will only
document application differences. Newer properties/functions cannot be used
in databases created in older formats so you are loosing functionality by
staying with the older file format.

 

[Brendan Reynolds]

There is an article at the following URL ...

http://office.microsoft.com/en-us/assistance/HP052817081033.aspx

.... which lists the following advantages for the Access 2002/2003 format ...

1) Provision for unknown properties and objects that might exist in future
versions of Access

2) Ability to save an Access file as an MDE or ADE while in Access 2002 or
later

3) Improved storage format