#Name? What does this mean?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Seen this out here before, but I have never seen an answer. What is this. I
have entered all of the criteria for a query, and it opens up, but when I
scroll across the columns I seem to reach one that casues all of the data in
all of the fields to be converted to #Name?. Thanks
 
Somewhere you've typed in the name of a field that isn't there at all or not
exactly right.

Other than that, maybe the database is corrupt. Do a Compact and Repair and
see if that fixes it.
 
The Compact and Repair didn't do it, but I removed one field called notes and
that seemed to stabilize the data. Thanks for your help.
 
I bet that Notes was a Memo data type. Memo fields are known to corrupt and
often compact and repair won't fix them. I avoid Memo fields for that reason
and make frequent backups when they are required.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Date Setting 1
Access Dcount (multiple criteria) 3
Aliasing a column header field name 2
Looking for Existing Records 2
what does this mean? 5
Excel Is this possible?? 3
Access 2003 Query - what does this <> mean? 4
Can't access memory stick 6

Back
Top