Woo!!! That's sorted it, SQL appeared, copy and pasted into new query, saved query and voila!! It's now appeared back in the query tab.
Thanks a million.
Yes I tried compact and repair but to no avail. Unfortunately I don't have the SQL for the query so I can't recreate it. Here's the weird thing, if I create a blank database and import the queries it still isn't visible. However, when I try to create another query with the same name on this new...
Hi there,
I've got an Append Query in an Access 2000 database that is not visible on the Query tab. I know it exists because when I try to create a new query and call it the same name it responds with "The name entered already exists for another object of the same type in this database"
I've...