Network Security Question with Acess

[JohnnyBQue]

OK here's a question for the IT guys....

I've completed my db and want to put a copy (not sure if "copy" is the correct word here) on several workstations for use. Now employees at these work station have different levels of access within the network. The IT guy is concerned that when the db is used at these workstations that the employee using the db will be able to access areas (directories) that they do not have the rights to so because they are not "logged in" as a "network" user.

Now my db does bring up files through a file path which is linked to a button and when clicked a folder opens revealing a number of file as it should do. But through this Open folder the user is now able to navigate back up the Directory trees. Now I've only tried this on my workstation, which I have close to Admin rights so this isn't a really valid test.

What I mean by test is I believe that who ever logs into the workstation that the "right" of that "login ID" is set to that workstation at that time no matter if using my db or what program that my involve navigating the network directory...

SO as long as the employee logging in has "rights" to the "folder" that may need to be accessed through my db (clicking the button) there shouldn't be any issues and if the User tries to navigate through the network directory they will be limited to access just as if they were NOT using the db...

The IT guy has never used Access so he's limited in the knowledge of how it may or may not effect network security.

any opinions are welcome

 

[gemma-the-husky]

I am not an expert. I suppose it depends whether access is inheriting the logged in user's rights, or say, administrator rights.

best way is to test it. See if a "limited" user can access files/folders that he shouldn't be able to.

 

[namliam]

Access and any programs opened by access or the user always work with the user's rights.

That is as far as my knowledge goes, but best way to test it is like dave said, make a dummy user (or find a co-worker) with way less priviliges and try.

 

[JohnnyBQue]

Thanks for all the reply's....I tried is with several employees and it is confirmed that the access rights for the User is set by network directory security setting associated to the Login ID

 

[gemma-the-husky]

glad you got it sorted.

I am sure both you and your IT guy will be happy with the result.