I have really weird problem that is driving me crazy. I had access backend and front end. I moved backend to SQL 2000 and kept the front end intact in Access. Now, It's seemed to be running fine. But every now and then, it does not populate the particular order( Order entry system),instead it would just display "#ERROR?" and "#Name?". The strange thing is, if I goto SQl backend to look for the specific order, it wud display it correctly. I have also noticed that the SQL linked tables in access would display "#NAME?" , if i try to open the tables in access itself rather than going into backend - SQL.
I am really lost here.