[AccessD] Migrating an existing linked FE-BE Access DB to SQL Server-best method?

Hello All,

I want to upgrade an existing Access DB to SQL Server with an Access user interface.  Just bought "SQL:Access to SQL Server" by Harkins and Reid.  They recommend creating an ADP, to "achieve the full benefits" of SQL Server.

My question: for an existing Access FE-BE DB, should I (must I?) re-work it as a stand-alone DB, and try to re-write all the DAO code in ADO, before proceeding with the Upsizing Wizard?

I'm an amateur programmer, but have been supporting a multi-user commercial DB that needs to be upsized.

Thanks,
JA