0
Technically, you could, but you probably shouldn't. Primary key fields are meant to uniquely identify each record in a table and they are meant to allow for quick searching. These are two reasons why it is generally not a good idea to use a Date/Time field as a primary key.
The chance is small, but two records could be inserted at exactly the same date and time, resulting in an error, because Access (and databases in general) doesn't allow for the insertion of two identical primary keys.
Secondly, most databases are better at searching through numeric id's than through dates.
It is better to use the AutoNumber ID that Access automatically provides when you create a new table and just add a Date/Time field to your table. If for some reason you want the dates in your table to be unique, you can set the Indexed value to Yes (No duplicates) in the Field Properties at the bottom of the screen in your table's Design view.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
In which date the interview result of primary teachers of purulia will be published?
You need to contact the institute concerned.
What is published date?
It is the date an article was published. It usually appears at the top or bottom of the article.
Date twilight was published?
I'm not sure the specific date but it was published sometime in 2005.
What is the date a book was published called?
publication date or release date
What is the production date of colt lightweight commander serial number CLW019760?
You need to call Colt. That sn does not appear in any published data I have access to. I believe about 1975
If an article doesn't have an author(s) what do you put in its place Or if it doesn't have a published date?
If an article doesn't have an author listed, you can use the name of the organization or website where the article is published in place of the author. For articles without a published date, use "n.d." (no date) in your citation to indicate that the date is not available.
What date was Charles Dickens A Christmas Carol published?
It was published on 17th December 1843
What was published in September 19 1787?
The U.S. Constitution was published for the first time on this date.
What date the book Four Blind Mice by James Patterson was published?
It was published in 2003
What is the access date for WikiAnswers?
In a list of sources, the access date for a website is the day that you visited the web site to obtain the information. For example, if you visited WikiAnswers today you would list today's date as the access date.
What date was Mary Poppins published?
1234
What date was it when answercom was published?
November 2006.
