Can the date published serve as a primary key in access?
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.