Share via

Microsoft Access #Name? Error

Anonymous
2020-02-03T01:25:45+00:00

When I saved my databases, all of the data entries suddenly showed up as "#Name?" I am not sure how to resolve this.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2020-02-04T03:28:01+00:00

    #Name? is shown if Access can't make sense of the ControlSource of a control.

    For example if I have a textbox with ControlSource of "FirstName" and that field does not exist in the underlying query (in the RecordSource of the Form), this would appear.

    Maybe you have a split database (good!) that has not been relinked to the new back-end database location. Use the Linked Table Manager to re-link.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  2. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2020-02-03T15:39:20+00:00

    What do you mean by "saved my databases"? I have never "saved" a database, only objects in the database like queries, forms, code, etc. 

    Where are you seen #Name? Is this in datasheet views of your tables or records viewed in forms?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments