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/AlbertKal...plit/index.htm
http://granite.ab.ca/access/splitapp/index.htm

--
Joan Wild
Microsoft Access MVP
"Ribcage" <(E-Mail Removed)> wrote in message news:E4088928-3714-4934-B715-(E-Mail Removed)...
>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.

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/AlbertKal...plit/index.htm
> http://granite.ab.ca/access/splitapp/index.htm
>
> --
> Joan Wild
> Microsoft Access MVP
> "Ribcage" <(E-Mail Removed)> wrote in message news:E4088928-3714-4934-B715-(E-Mail Removed)...
> >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.
>

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.

"Ribcage" <(E-Mail Removed)> wrote in message
news9687A8A-CEAC-4082-BD17-(E-Mail Removed)...
> 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/AlbertKal...plit/index.htm
>> http://granite.ab.ca/access/splitapp/index.htm
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>> "Ribcage" <(E-Mail Removed)> wrote in message
>> news:E4088928-3714-4934-B715-(E-Mail Removed)...
>> >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'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
"Ribcage" <(E-Mail Removed)> wrote in message news9687A8A-CEAC-4082-BD17-(E-Mail Removed)...
: 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/AlbertKal...plit/index.htm
: > http://granite.ab.ca/access/splitapp/index.htm
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > "Ribcage" <(E-Mail Removed)> wrote in message news:E4088928-3714-4934-B715-(E-Mail Removed)...
: > >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.
: >