Home All Groups Group Topic Archive Search About

User level security

Author
20 Apr 2009 5:29 PM
Majed
I used to have a user level secuirty on the DB, and I think because I copied
it the user level secuirty is not working anymore. That's fine with me. I
don't need it anymore. When I copy the database from one computer to another
or to a laptop also it works, but when I upload the database to a server for
some people when need to work on it doesn't let them open the database. I
don't know the exact error message that they get but I guess it talks about
administration privileges. I wanna know what the heck is going on

Author
21 Apr 2009 2:53 PM
Joan Wild
Copying a mdb file does not remove security.  Since the copy appears to
have no security, then your original was not secured properly.

However, since it doesn't matter to you, on to your other problem.  All
users of the file need create permission (Windows permission) on the
folder where the mdb file is located.  However you should split the mdb;
only the backend would sit on the server; each user would get a copy of
the frontend on their PC.

More info on splitting:
  http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
  http://www.granite.ab.ca/access/splitapp/overview.htm


Joan Wild
MS Access MVP


Majed wrote:
Show quoteHide quote
> I used to have a user level secuirty on the DB, and I think because I copied
> it the user level secuirty is not working anymore. That's fine with me. I
> don't need it anymore. When I copy the database from one computer to another
> or to a laptop also it works, but when I upload the database to a server for
> some people when need to work on it doesn't let them open the database. I
> don't know the exact error message that they get but I guess it talks about
> administration privileges. I wanna know what the heck is going on
Author
21 Apr 2009 4:43 PM
Majed
Thank you so very much for all the help you'r giving everybody Joan

Show quoteHide quote
"Joan Wild" wrote:

> Copying a mdb file does not remove security.  Since the copy appears to
> have no security, then your original was not secured properly.
>
> However, since it doesn't matter to you, on to your other problem.  All
> users of the file need create permission (Windows permission) on the
> folder where the mdb file is located.  However you should split the mdb;
> only the backend would sit on the server; each user would get a copy of
> the frontend on their PC.
>
> More info on splitting:
>   http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
>   http://www.granite.ab.ca/access/splitapp/overview.htm
>
>
> Joan Wild
> MS Access MVP
>
>
> Majed wrote:
> > I used to have a user level secuirty on the DB, and I think because I copied
> > it the user level secuirty is not working anymore. That's fine with me. I
> > don't need it anymore. When I copy the database from one computer to another
> > or to a laptop also it works, but when I upload the database to a server for
> > some people when need to work on it doesn't let them open the database. I
> > don't know the exact error message that they get but I guess it talks about
> > administration privileges. I wanna know what the heck is going on
>