From here it looks as though Method 1 and Method 2 are the same.  Both say,  "All primary keys are named ID."  Am I missing something?

Thanks for this - I'll check out Access Projects.  Meantime, I had intended to merely store the tables in SQL Server (Express 2005), and use Access as a front end...

I had much difficulty with the upsizing wizard in Access.  It may be because I was using Access 2000.  However the Access 2003 version was also not satisfactory.

I found on...