From: Caro on
I'm trying to delve into a database that was originally developed in earlier
versions of Access, and now has been converted to Access 2007.

All I'm doing right now is looking at objects and documenting them, but I'm
finding frequent occurrences of the database hanging up (sometimes) when I
open the query window for a form's record source, view it in SQL view, then
close SQL view then try to close the query window.

Any ideas on this wierdity?

--
Carolyn Kay
Chicago, IL
From: Nigel on
I had a similar problem with a couple of Queries and Forms.

I opened them in Design View, made a minor change and saved the Query or
Form. Then opened it in Design View again, reversed the change, and saved
again.

This seemed to solve my problem.

"Caro" wrote:

> I'm trying to delve into a database that was originally developed in earlier
> versions of Access, and now has been converted to Access 2007.
>
> All I'm doing right now is looking at objects and documenting them, but I'm
> finding frequent occurrences of the database hanging up (sometimes) when I
> open the query window for a form's record source, view it in SQL view, then
> close SQL view then try to close the query window.
>
> Any ideas on this wierdity?
>
> --
> Carolyn Kay
> Chicago, IL