Error has occurred working with Microsoft Access

Asked By 45 points N/A Posted on -
qa-featured

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

SHARE
Answered By 10 points N/A #184379

Error has occurred working with Microsoft Access

qa-featured

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.

Related Questions