C
carolannedlg
I have created a number of complex queries, all of which work fine.
Recently I have created a new query which is based on calculations in
three other queries. Unexpectedly, after adding a number of columns to
the query (more than 20) if I click Save or Design View while in this
query, Access shuts down instantaneously without warning or error
message!!!
I have tried several things such as different computers, recreating the
query, etc. and every time (four different attempts) the same thing
happens. In some instances both the query itself and a query built on
top of the query in question have both become corrupted.
The query is only slightly different then others in the database that
work fine, the primary difference being the number of columns is
greater.
If anyone has any suggestions for things to look for or has had similar
experiences, any info would be greatly appreciated.
Perhaps there is a maximum column number or maximum number of queries
that can be built on top of each other?
Recently I have created a new query which is based on calculations in
three other queries. Unexpectedly, after adding a number of columns to
the query (more than 20) if I click Save or Design View while in this
query, Access shuts down instantaneously without warning or error
message!!!
I have tried several things such as different computers, recreating the
query, etc. and every time (four different attempts) the same thing
happens. In some instances both the query itself and a query built on
top of the query in question have both become corrupted.
The query is only slightly different then others in the database that
work fine, the primary difference being the number of columns is
greater.
If anyone has any suggestions for things to look for or has had similar
experiences, any info would be greatly appreciated.
Perhaps there is a maximum column number or maximum number of queries
that can be built on top of each other?