We have a desktop application using C++/MFC/ODBC to create the database.

We want to create a database that can upsize to a sql server database with bigint primary keys (64 bit primary keys).

What data type should we choose that can upsize cleanly from a jet *.mdb database to a MS SQL Server database?