Question about Microsoft Office Standard for PC
Can there be two primary keys for a table?
No, there cannot be two primary keys in one table. You can specify more than one value to make up the primary key. For example, instead of just the last name column - you can have the last name and employee ID fields make up the primary key. If you don't specify a primary key, MS Access will usually ask you if you would like them to create it for you. You may be thinking about foreign keys. A table can have two or more primary keys in them but they would serve as foreign keys. For example - lets say you have table A with primary key "A" and table B with primary key "B". You can create table C and have both primary keys from tables A & B in it, however, they would be foreign keys in table C and not primary keys (they are only primary keys in their respective tables).
Posted on Oct 03, 2007
Tips for a great answer:
are some reasons which may damage your MS access database such as
virus infection, software crash, accidental shutdown of system,
unrecognized format of database, corruption of storage media etc.
These issues are easy to overcome by using third party software of
access database repair.you can try Kernel Access Database Recovery Software one of the best software in Data Recovery
For information you can visit here ...http://www.accessrecoverytool.net
Usually answered in minutes!
Step 2: Please assign your manual to a product: