CONVERTING LOTUS DATABASE TABLES TO ACCESS

[chiefvj]

I took over a Lotus database that was created using Lotus Approach. I was able to convert the tables to Access 2007. However, the tables have no key fields. How do I create a key field without generating an error message saying duplicate fields will be created?
thanks for any help.

 

[Remou]

You can:
- add an autonumber field, if that is suitable, or
- eliminate duplicates in the natural key
- use more than one field as a key, if that creates a natural key.