Re: Access

I have a number of tables where the PrimaryKey is DateTime.

I just noticed that in one of the tables contains multiple records with the same DateTime. Most likely this is because Access only goes out to seconds and the double value that represents DateTime may go out to more precision.

Looking for recommendations on how best to handle both entry and seeking
records?

One thought was to make PrimaryKey AutoNumber and the store DateTime as Text in a yyyymmddhhmmss format and make this unique -- or I guess it could even be the PrimaryKey since a Text field.

Suggestions/Comments/Recommendations?

Thanks
David