N/APosted on - 02/15/2014
When I am working with Microsoft Access, a window popped up with an error message. I was trying to create a database, all of sudden I got this error message. Still I am able to continue with the database. What might have caused this issue? Please help me to fix the problem. Thanks.
An error has occurred.
Correlation ID: 690afc9b-4032-c037-17c0-a6c36b9f47fc
Date and Time: 2/5/2013 11:4842 PM
Error has occurred working with Microsoft Access
The DATE_CORRELATION_OPTIMIZATION database option is set to ON, and that is the reason why you see the warning. Access maintains correlation statistics between two tables which are having date or datetime columns and are linked by FOREIGN KEY constraint. Tables whose date or datetime column values are correlated can benefit primarily for decision support, reporting, or data warehousing purposes and this is typically part of a one-to-many relationship and is used. I do not see any problem with the error message and it is rather a safe guard.