I have done a complete redesign on an existing database with 4 years of information and a few hundred thousand records preexisting. Now I run into the problem of importing my old data while ...

When you create a Microsoft Access table, Access will automatically create a primary key to your database table. Still, you can also specify the field you want as the primary key for your database ...