Error has occurred working with Microsoft Access

Asked By Rosalie C Grubbs 45 points N/A Posted on - 02/15/2014

Hello Pro,

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.

Microsoft Access

An error has occurred.

TECHNICAL DETAILS

Correlation ID: 690afc9b-4032-c037-17c0-a6c36b9f47fc

Date and Time: 2/5/2013 11:4842 PM

OK

• Status: Open
• Question Views: 854
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Tim Lahaye 10 points N/A #184379

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.

About Tim Lahaye

Questions
3

Answers
256

Best Answers
20

• Vote Up 0 Vote Down

• Posted on - 03/08/2014
• Question Category: MS Access