I am seeing "No current record" when I run a query that used t run fine

[Pack10]

I have a database that has linked tables to a (desktop) SQL Server db. Last week I accidently de;eted a table.
I have re-populated the data and re-linked to SQL Server database, but now a couple of my queries now display
"No current Record" when I run them. I have rebuilt the queries and when I remove some of the fields from the table that I recreated
the query runs....If I add them or one of the fields back to the query.... i receive "No Current Record"....

Any ideas?

 

[dhookom]

When you state "when I remove some of the fields from the table" are you actually deleting columns in the table in SQL Server or are you choosing to not display some fields in the query?

Did you duplicate the indexes from the deleted table?
Are the data types the same?

Can you share more information about your tables, relationships, and SQL views?

Duane
Hook'D on Access
MS Access MVP