Permissions

  • Thread starter Thread starter Ribcage
  • Start date Start date
R

Ribcage

I need to be able to share a database with colleagues on a shared server.
I have copied the Database file to the server and set up shortcuts on their
desktops to this Database. It will only give them "read only" access to it. I
need them to be able to enter data.
I know that I need to set up something using permissions but have been
trying unsuccesfully for a couple of days now.
Could someone give me a click by click idiots guide on how to do this please?

Thanks in anticipation.
 
You need to adjust the Windows permission on the folder where the mdb is located. All users need read/write/create/delete permissions on the folder.

That said, you should split the mdb. Put the backend (mdb with just the tables/relationships) on the server, and give each user a copy of the frontend (mdb with all other objects and table links to the backend) on their PC.

More on splitting:
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
http://granite.ab.ca/access/splitapp/index.htm
 
Thanks for the response Joan but I am still none the wiser.
Don't I have to set up something under the Tools / Security Menu witnin
Access?
It talks about creating a file in a shared folder? I don't think I'm stupid
but this has got me completely confused.
 
The users need read/write/create/delete permissions for the folder in which
the database is located. This is set up by the network administrator. It
is not an Access setting.
As Joan said, splitting the database is a good idea in general, but is an
especially good idea in a multi-user environment. The links she provided
have more information on the subject. However, this is not directly related
to the security issues you have encountered.
 
You're confusing Access security and Windows security.

If you're going to share a mdb file, it needs to be located in a folder that is shared by all the users. Those users need sufficient Windows permissions on the folder in order to use the file.

That is all you need to do to share a mdb. It's 'shareable' right out of the box. You don't need to do anything in the Access security menus.

Having said that, if you want the mdb to run smoothly, you should always split a mdb that's going to be shared.

--
Joan Wild
Microsoft Access MVP
: Thanks for the response Joan but I am still none the wiser.
: Don't I have to set up something under the Tools / Security Menu witnin
: Access?
: It talks about creating a file in a shared folder? I don't think I'm stupid
: but this has got me completely confused.
:
:
: "Joan Wild" wrote:
:
: > You need to adjust the Windows permission on the folder where the mdb is located. All users need read/write/create/delete permissions on the folder.
: >
: > That said, you should split the mdb. Put the backend (mdb with just the tables/relationships) on the server, and give each user a copy of the frontend (mdb with all other objects and table links to the backend) on their PC.
: >
: > More on splitting:
: > http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
: > http://granite.ab.ca/access/splitapp/index.htm
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > >I need to be able to share a database with colleagues on a shared server.
: > > I have copied the Database file to the server and set up shortcuts on their
: > > desktops to this Database. It will only give them "read only" access to it. I
: > > need them to be able to enter data.
: > > I know that I need to set up something using permissions but have been
: > > trying unsuccesfully for a couple of days now.
: > > Could someone give me a click by click idiots guide on how to do this please?
: > >
: > > Thanks in anticipation.
: >
 
Back
Top