User level security

  • Thread starter Thread starter Majed
  • Start date Start date
M

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
 
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
 
Back
Top