I'm trying to pick up work on an on again off again project that hasn't seen the light of day for about two months. Its running off of a microsoft desktop sql server, and recently something seems a bit out of order.
My interface doesnt' seem to have any problem getting data from the tables. However if I manually try to open them, some of the tables don't respond, or come back with the message "the query operated succesfuly but returned no results" or something to that effect.
I can copy and paste the tables, and access the copy, so its not a matter of losing data. Everything still functions just fine, I just can't reach into the hood or change my variables in that way.
Has anyone run across this before, and have you found a solution?
My interface doesnt' seem to have any problem getting data from the tables. However if I manually try to open them, some of the tables don't respond, or come back with the message "the query operated succesfuly but returned no results" or something to that effect.
I can copy and paste the tables, and access the copy, so its not a matter of losing data. Everything still functions just fine, I just can't reach into the hood or change my variables in that way.
Has anyone run across this before, and have you found a solution?
