Re: Permissions

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
"Ribcage" <Ribcage@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E4088928-3714-4934-B715-E7350ADD5742@xxxxxxxxxxxxxxxx
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.
.

Relevant Pages

  • OK, heres what i tried...
    ... I added the IWAM_machine account with no effect. ... groups with the expected permissions. ... Noticed the CREATOR OWNER was on that folder after i ... >are using FrontPage and storing the mdb within the web ...
    (microsoft.public.windowsxp.security_admin)
  • Re: OK, heres what i tried...
    ... > groups with the expected permissions. ... > Noticed the CREATOR OWNER was on that folder after i ... >>AFAIK a grant to Creator Owner is irrelevant. ... >>are using FrontPage and storing the mdb within the web ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Access97 DB locks up the asp code at times
    ... The .ldb file is created when the database is accessed & deleted after ... > problem with the folder. ... > I'll chat with our IT group about setting the proper permissions. ... My goal is that everyone can run the asp that accesses the mdb ...
    (microsoft.public.inetserver.asp.general)
  • Re: Why Are "Permission Entries" changed
    ... If you are setting the permissions on the actual database file then the ... The compression routine works like follows (well, ... MDB ==> Compressed MDB ...
    (microsoft.public.win2000.security)
  • Re: Adding new users to an Access 2002 DB
    ... So the mdb opens when you are using the standard system.mdw. ... It sounds like someone didn't secure it properly, ... When you open it, go to Tools, Security, permissions and check to see what ...
    (microsoft.public.access.security)