Access 2010 permissions problem

[atrium]

I have a relatively large application accessed by 14 - 16 users.

I have created a module that allows the user to select an action plan. An Action Plan represents a list of word templates with Book Marks so the system can perform a merge and fill in the details of the current Client into all of the documents within the Action Plan selected.

For me and another couple of users (with Windows Admin rights) it all work perfectly.

Other users get a "Run Time Error 91 - Object variable with Block variable not set"

I have looked at the Trust settings for both types of users and they are the same.

If I log onto the server and then log into our access 2010 application - I do not get the error.
If I log onto the server and then log into our access 2010 application - as one of the other users I do get the error.

If I log onto the server using the other users login details and then log into our access 2010 application with my login details - I do not get the error.

If I log onto the server using the other users login details and then log into our access 2010 application with Theiry login details - I get the error.

The login details into the network are nothing like the login details into our access 2010 application

Any ideas why this error occurs only for some users.

 

[Minty]

I'm slightly puzzled by what you mean by "then log into our access 2010 application with my login details" . How / why are you logging in to the access application?

 

[JHB]

Show the code (and mark the line) in which you get the error.

 

[arnelgp]

through code you can copy the word template to local computer and manipulate the docs from there.

 

[gemma-the-husky]

is there any conditional code in your app testing the current user?

I imagine the best way is to run the code version of the app under the "faulty" permissions, and set a breakpoint. Then you can trace the programming execution.

 

[The_Doc_Man]

Question: Are you logging in using domain-style logins? And are you then using something like Citrix or another terminal-services case to connect to the DB?

Frequently, you get permissions from your domain login based on your group membership, and if you are in a different group than your problem users, you have an immediate place to look - the permissions associated with the respective groups.

 

[atrium]

Thanks for your responses everyone. On reflection my login to the access application is purely a check on the user name and password against an access table entry. Has nothing to do with permissions etc.
I'm sure my problem lies in the differences in terminal server profiles across users.

Our users login to our terminal server to gain access to their server desktop, the access application is purely a desktop icon they click.

Could it have something to do with the permissions relative to automation of word within access ??

atrium

 

[The_Doc_Man]

Any time that users "step outside" of the folder where Access is active, there is a shot at running afoul of permissions. Is the Word document in the same folder as the Access BE file or is it elsewhere. In essence, if you granted Modify access to folder X for domain group G because that is where the Access file is located, but the Word document is in folder Y, you probably ALSO need for group G to have Modify rights on folder Y.

This is also why you want to use domain rights as often as possible, since all you have to do is get the rights set up for groups once, then make your users members of the group - and you are done!

 

[gemma-the-husky]

one other point. I presume your error is trappable.

you ought to error-trap the file handling, so rather than get the error you did, you can recover gracefully. or use a Boolean function to open the file, so again you can recover.


eg

process
on error goto fail
open some file
process
exit sub

fail:
handle the error

or

 process
 if not BooleanFunctionToOpenFile then
    exit sub
 end if
 process

BooleanFunctionToOpenFile now needs to contain error handling protection to report failure.

 

[atrium]

Thank you everyone for your help

after stepping through the code when logged in as one of the users I discovered that the code was trying to access a file in a folder that no longer existed.

Due to a crypto virus getting into our system 4 weeks ago and in the rebuild we deleted a lot of redundant folders - the folder in question was deleted.

Thanks again everyone for your help

Atrium