You mentioned "With out altering the code in the ASP app". 

What are the options for if I am willing to change the ASP code?

-JD

Rawhide nailed it on the head.  The "enable identity insert" checkbox was all that I needed to change.

Thanks a bunch!

-Merc

Right-clicking any given table, using the import functionality listed under "all tasks".  I select the MSAccess database to import from, then select my SQL server DB to import to.  I...

I am using the "ignore" functionality for the id column, and only trying to bring in the description field.

-Merc

Thanks!  I had asked around on a lot of forums, and found just what you said (that my suggested design change is the "correct" way to go), but no one...