User level security

[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

 

[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]

Thank you so very much for all the help you'r giving everybody Joan