KB#00665-An SQL query in MS Access results in ' #Name?' in every field
An SQL query in MS Access results in ' #Name?' in every field
When another user has a record locked in data file that's being queried, MS Access may fill all fields in the result table with #NAME? This problem can be demonstrated by using VPRO/5 and MS Access 97 via the following steps:
1) In VPRO/5, extract a record
2) Perform a query in Access that references the same data file and field.
3) Scrolling to end of the resultant table will cause the behavior mentioned above. You will see a "Busy Time out error" but all the fields will change to #NAME?
Last Modified: 06/22/1998 Product: BASIS ODBC Driver Operating System: N/A
BASIS structures five components of their technology into the BBx Generations.