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.
What else can I help you with?
In which date the interview result of primary teachers of purulia will be published?
You need to contact the institute concerned.
Date twilight was published?
I'm not sure the specific date but it was published sometime in 2005.
What is published date?
It is the date an article was published. It usually appears at the top or bottom of the article.
How can I find the date published of a website?
To find the date a website was published, look for a "Last Updated" or "Published On" date at the bottom of the webpage. You can also check the website's "About" or "Contact" page for more information.
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 the book Four Blind Mice by James Patterson was published?
It was published in 2003
What was published in September 19 1787?
The U.S. Constitution was published for the first time on this date.
What date was Charles Dickens A Christmas Carol published?
It was published on 17th December 1843
What date was it when answercom was published?
November 2006.
What date was Jurassic Park published?
1990
