A client for whom I have created several databases in Access 2003 will be upgrading to Access 2010 at the end of the year. I am currently in the middle of developing a database for them, still in 2003, that will be finished around the time that they will be upgrading. I have three questions:
1) What should be done with their current Access 2003 databases? Should I convert them or can they be used as is in Office 2010?
2) Should I continue to work on the new database in Access 2003 and then convert to 2010 once I've finished or should I convert now? I don't have Access 2010 now, but I can get it soon if it would be better that way.
3) What are the difficulties / complications in converting a database from Access 2003 to Access 2010?