One user cannot access one form
-
This is kinda strange. Access XP database, it's been split and linked into a front-end with all of the forms and reports and a back-end with all the data. The links are through explicit pathing, not UNC names. Multiple people are using this. And there's no security coded in the system.
I have two users who cannot access one form in the system and also cannot access most, if not all, reports. All of the other users, as far as I know, have no problems accessing anything. I've repaired the thing, I've restored it from a previous backup. Still no joy.
(I'm new to this job and don't have network admin access, just SQL DBA admin access, which kinda hampers my troubleshooting. I'm moderately skilled in Access, though very rusty.)
The problem is not machine-specific as the user can log on to her PC as someone else and has access to the one form and all reports. Which leads me to believe that it is profile or permissions specific. I don't think it can be permissions specific as network permissions apply to the file level, they shouldn't affect anything within the MDB. The help desk guys say that they have deleted the user's profile from her PC and recreated it, yet the problem persists.
Any suggestions?
-
Can she open the table or view that the form uses?
-
Yep. I was just there and I could open the base table.
(I was logged in under the wrong account
)-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
It could be a filter in the form.
-
I don't follow. The form does not open, it's not that there are no records when it opens. How would a filter prevent the form from opening?
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
Latest attempt at getting it working:
One of my bosses said that Access throws temp files all over the place, and that perhaps one of them was hosed. I cleared out the system temp directory, flushed her browser cache, did a scan disk and optimized the hard drive. No change. I also tried copying the front end to her desktop, no change.
The guy who wrote this system is coming in this afternoon to look at it, but I'm off this afternoon, so I won't hear any more on this until Monday.\
My next strategy, barring anything else, is to upsize the back end to SQL Server and re-point the front end and see if that works. It's a relatively small database, so that shouldn't be difficult. I'd've done it today, but two other systems blew up that required my attention.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
In Access you can hide objects like forms. So, if your users are trying to open the form from the "Forms" section and can't see it, have them go to
Tools->Options->View and check "Hidden Objects".
Otherwise, you said there is no security implemented in the Access db, but are you sure?
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor -
I haven't looked into hidden objects, I doubt there are any. I'm fairly sure there is no security in this database, I'll dig into it further.
The form is visible. The system has a switchboard (I hate that term) where the user can open this form. When they click the button to open it, it opens with an error trap. If you bypass the switchboard and try to open it straight from the database object container, it simply does not open. You get an hour glass, then the hour glass goes away with nothing happening. If you open the table that the form is linked to, it opens just fine. And other users (or her workstation logged on as another user or with her logged on as her on another workstation) can open the form just fine.
WHEEE!!!
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
what is the error when it opens from the switchboard?
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor -
OK, I quit.
It is now fixed, and you're not going to believe the resolution.
It was a corrupt printer driver.
I have no idea how the guy who developed it diagnosed it, but he came out Friday and determined this, this AM the user had our help desk uninstall and reinstall the printer driver, and now it works.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply