1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

#NAME in Access

Discussion in 'Business Applications' started by SoldierC, Oct 22, 2019.

  1. SoldierC

    SoldierC Thread Starter

    Joined:
    Oct 22, 2019
    Messages:
    1
    I have a SQL database with an Access front end. About 30 people use the database on a daily basis. A couple days ago one of the users started getting #NAME in all of the text boxes. No other user is having this issue. I have already deleted and reinstalled the front end and it didn't change anything. As far as I know he doesn't have this issue with any of the other databases and I know he is the only one that has this issue with this one. Before people start talking about naming conventions and compacting and repairing (yes I have tried to search for an answer) it is only one user out of 30+ and it is only this one database. Any help would be greatly appreciated.
     
  2. Chawbacon

    Chawbacon

    Joined:
    Jul 9, 2018
    Messages:
    494
    First Name:
    Jack
    Hello SoldierC,

    In my experience, the #Name in all boxes is due to the Front End DB not linking correctly to the Back End DB. I would initially look at the user's file and folder permissions where the target Back End DB resides, or that the physical/logical path to the Back End DB actually exists for the user.

    Good Luck!
     
  3. Fireflycph

    Fireflycph

    Joined:
    Apr 1, 2016
    Messages:
    1,046
    First Name:
    Morten
    Without knowing exactly how the front end is set up. I have had this issue when, as Chawbacon states, there either wasn't correct credentials entered or if those credentials didn't have access to a "Linked" table/Query.

    First thing to check, in my opininn is to check that the user ID has access to any and all databases on the SQL back-end. Second to check the actual file rights.

    I believe that this issue if for one user only, and follows him/her regardless of which device they log on to. Please confirm that though.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...

Short URL to this thread: https://techguy.org/1234606

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice