Share via

Creating Shared Folder at Work for Back End Access Database

Anonymous
2017-01-05T18:43:08+00:00

Hello, I am taking tutorials on how to set up a Shared Folder to house the back end tables of an Access database so multiple users can access the tables. The tutorial says to create the folder and go to the Sharing Properties of that folder and select the check box to Share this folder, set permissions (i.e., delete Everyone in the permissions box and add selected users). 

  1. I'm at work and we have a network drive where we have many shared folders. Can't I just create another folder there and I'm done? As long as I put it in a place that only the users and I will go to, maybe making it hidden, or with a note in the folder to not access the backend unless an administrator? I say that b/c...
  2. The shared folder I did create on the network does not have a Sharing Properties tab when I right click it--see below--so I can't set permissions. So, could the Sharing Properties tab be disabled and I need to ask the IT Dept. how to set permissions, if I'm even able to? (I can access the Sharing tab with folders on my Desktop but a message says System Administrator Has Blocked You, etc.) 

Thank you.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

ScottGem 68,830 Reputation points Volunteer Moderator
2017-01-05T19:02:52+00:00

You should be talking with your IT department about this first. There may be policies and procedures for setting up folders. users should not just take it on themselves to do it.

It sounds like your IT dept has set group policies that prevent users from setting permissions. This is not uncommon. it also matters where you create the folder. You may need to create it under a specific network share or as a subfolder, that you may have rights for setting permissions.

Another point is you generally do NOT want to grant rights to individual users. Instead you want IT to create a Group and grant rights to the group, then control access by adding or removing people from the group.

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2017-01-05T19:29:06+00:00

    You should be talking with your IT department about this first. There may be policies and procedures for setting up folders. users should not just take it on themselves to do it.

    It sounds like your IT dept has set group policies that prevent users from setting permissions. This is not uncommon. it also matters where you create the folder. You may need to create it under a specific network share or as a subfolder, that you may have rights for setting permissions.

    Another point is you generally do NOT want to grant rights to individual users. Instead you want IT to create a Group and grant rights to the group, then control access by adding or removing people from the group. 

    Thank you very much, Scottgem. I will speak to the IT Dept. about this. And I did not realize this about IT creating a Group. Thank you.

    Was this answer helpful?

    0 comments No comments