Query Fields Not Showing in Expression Builder or Elsewhere

[Xcalibur]

In Expression Builder and other areas of Access where the fields of a query show, my fields are not showing anymore for any of my queries. Does anyone have a solution for this?

Thanks.

 

[Uncle Gizmo]

Make a backup copy before you do anything,

have you deleted some queries or tables Somewhen?

 

[Xcalibur]

Make a backup copy before you do anything,

have you deleted some queries or tables Somewhen?

It is very strange, the only place you can see the fields is in the actual queries in any mode. Anywhere else that you try to call the query fields from they just don't show, it looks like all the queries are empty. One minute they were there and then they weren't. It has happened before but they came back before this time they didn't. I haven't deleted anything.

Thanks.

 

[Xcalibur]

I have discovered the reason the fields are disappearing. If any query isn't working for some reason (even if it isn't apparent), any queries even remotely connected to it will not show their fields for selection anywhere. The queries that are not connected to it will still show there fields. As most of my queries are based back to the one, it appeared that all queries were affected.

Strange but true.