Permissions

[AccessNewbie]

I replaced an access genius and I'm taking classes to learn access. I have
multiple access mde programs that use the same mdb file for permissions. the
permissions are set up by ntlogin id, then by dept code, then by a number
(1-4) - the number sets how much they can edit, add or delete, the dept code
only allows the user access to information in thier dept, the ntlogin is
automatic from the initial login into the network. The permissions mdb has
two tables and between these two tables all six mdb programs get their
permissions. I hope this is understandable. What I'm trying to find out is
how are these permissions set and how is the ntlogin used (from the initial
login into the network vs a separsate login into access). The ntlogin id is
also used in reports. Also, the original mdb files for the six mde programs
were taken by the former employee and not accessible. I will be remaking
these programs one by one and would like to use these same permissions.
thanks for any and all help.

 

[Tony Toews [MVP]]

Also, the original mdb files for the six mde programs
were taken by the former employee and not accessible.

Then the company lawyer should be writing this person a very strongly
worded letter and then, if necessary, sue him.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[AccessNewbie]

Tony,

Thanks -- and there are people working on that issue. But, I still need
help and unfortunately your answer didn't provide an answer that will help
me. Hopefully you or someone else can help me and I can work on some
replacement databases.