Developing a point-of-sale system that uses a MS Access database. We'd like to use our program to create all the necessary tables and their fields in the database when the user starts up a new company ...

I'm trying to update multiple records using a non-primary key. However, it only updates the first row it finds and not all rows.<BR>Is this possible or do updates require a primary key (and therefore) ...