Query won't open in design view

[Laurie]

Hello,

I have a query that we haven't used in quite a while. We need to open it and
change it so that it's active for this year-- currently, it's set on last
year's data. It's a make-table query. We are not trying to run it, just to
open it in design view. When we try to open in design view, the hourglass
icon appears for a second, and then disappears, and the query doesn't open.
Nothing happens, and there is no error message.

I've never seen this before-- what could be causing it? What can we do to
fix it?

Thanks!

 

[S.Clark]

Repair & Compact the database

If that doesn't work, try to extract the SQL using code, then create a new
query using that SQL.

Sub GetQuerySQL()
Dim qry As QueryDef
Set qry = CurrentDb.QueryDefs("qryPM_HistoryTime2")
Debug.Print qry.sql
End Sub

 

[Laurie]

Thanks! Compact and repair worked like a charm.