I am maintaining a pretty large Access 2003 project with a MDB data file on the server and linked tables. The plan is to upgrade to Access 2007 (or even 2010) and SQL Server as the data storage.
As this is a two-step plan, which of these steps is best done first? Does it make a difference if I first upgrade to 2007, or should I link to SQL first?
It doesn't matter. I would go to access 2007, let the 2007 do the migration, check everything, and then go for the sql server. But - nothing will happen if you take the other way. I think it will be easier to disconnect the mdb and connect to SQL in Access 2007, Rather than in 2003.
You may wish to read Allen Browne for additional information on the conversion to 2007.