General - Access 2007 - Open 2003 database vs. Saving 2003 database

Hi,

We are currently in the process of upgrading from Access 2003 to Access 2007 and are doing testing of the 2003 databases in 2007.

My question is, would there be any difference in the testing results and performance if:

1. Opened 2003 database in 2007 and did all testing without saving 2003 database as a new 2007 database.

2. Opened 2003 database in 2007, then saved it as a 2007 database, then closed the 2003 database and opened the newly saved 2007 database to do testing.

Thank you for your answer,

Mitch

I would make copies of db first. and open a copy with 07 since you never know what kind of problems may accur. Converting it, saving it and after testing is I think the best way but you can stay with the current version of database also.Since you want to test it for the 2007 then convert it first. ( Keep Original DB as how it is ) I didnt have any problems with small databases both at current version or after convert. But Hey this is just my experience which isnt much, wait for a Proffesional Reply from here.

I agree with vepaccess to make a copy of your 2003 version of the db first before you try to convert. Keep in mind that there are some capabilities in 2003 version that is not available in the 2007 version. If you use 2003 version capabilities such as user level security, replication, etc you will need to stay with the 2003 version in order for it to work in Access 2007. If you convert to 2007, the earlier mentioned capabilites will no longer be available.

See http://allenbrowne.com/Access2007.html#Bugs for more info on capability and bugs issues with 2007