L
Lovespar
I have inherited a database and after examining the tables I have discovered
that there are no primary keys. I do have an Autonumbered field as a "Record
Number"
this database has only 5 tables and none are related. Most of the data is
kept in one huge table. Could this be the reason it takes 3-4 minutes to
open? there are only 145 records in the main table.
the other 4 tables look to be set up so that drop downs can be put on the
main form.
Would anything be hurt is I add a primary key to the Auto number field?
that there are no primary keys. I do have an Autonumbered field as a "Record
Number"
this database has only 5 tables and none are related. Most of the data is
kept in one huge table. Could this be the reason it takes 3-4 minutes to
open? there are only 145 records in the main table.
the other 4 tables look to be set up so that drop downs can be put on the
main form.
Would anything be hurt is I add a primary key to the Auto number field?