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.
: >
