Access 2003 file format advange?

[Sirocco]

We're upgrading our system from Access 2000 to Access 2003. I'm aware
that version 2000 databases can be opened in Access 2003 without conversion,
and it did, in fact open, but are there any benefits to converting the
database to version 2003? Or, are there reasons why our 2000 database
should NOT be converted to 2003? It's hard to beleive that it wouldn't
matter one way or the other, and think there must be some advantage to
converting to a file format of "2003" if we're using Access 2003.

Many thanks in advance.

 

[Mike Wachal]

We're upgrading our system from Access 2000 to Access 2003. I'm aware
that version 2000 databases can be opened in Access 2003 without conversion,
and it did, in fact open, but are there any benefits to converting the
database to version 2003? Or, are there reasons why our 2000 database
should NOT be converted to 2003? It's hard to beleive that it wouldn't
matter one way or the other, and think there must be some advantage to
converting to a file format of "2003" if we're using Access 2003.

Many thanks in advance.

Check out the article at
http://msdn.microsoft.com/library/?url=/library/en-us/dnacc2k2/html/odc_ac
Format.asp?frame=true. It discusses Access 2002, but the file format has
not changed in Access 2003, so all the comparisons are still valid.

One additional benefit that is specific to Access 2003 comes when using a
digital certificate to sign your database (new functionality in 2003).
Performance of a signed database is significantly better when the database
is in the 2003 format.

--
Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Sirocco]

I get a "page cannot be found" when I click on your link. What does the
page describe?

Thank you.

Check out the article at
http://msdn.microsoft.com/library/?url=/library/en-us/dnacc2k2/html/odc_ac
Format.asp?frame=true. It discusses Access 2002, but the file format has
not changed in Access 2003, so all the comparisons are still valid.

One additional benefit that is specific to Access 2003 comes when using a
digital certificate to sign your database (new functionality in 2003).
Performance of a signed database is significantly better when the database
is in the 2003 format.

--
Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no

rights.

 

[Mike Wachal]

The article is quite long; more than I can describe here. It looks like the
URL broke across a line, you need to get the whole URL from the http: all
the way to 'frame=true' on the next line.

Alternatively, I just created

http://tinyurl.com/2osas

that should link to the same page and should have a problem breaking.

--
Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.