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.
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.
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.
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!