Network user login with previleges and audit trail

[srinivasbharat]

I am in the process of creating a database with multiple tables. Multiple users access through network with access data back end on server and Different Forms with user and group access of MS Access. The file is in mdb format and current version of MS Access used by all my users is Access 2007.

Requirements :
1. User Login (Access user login preferred as, one can set permission for read only, write permission for specific field etc.) But whether if any user who has readonly rights create his own db, wont be able to edit their own because of the rights that i have set rights in their pc??

2. need to fetch this user id with time stamp in each table to find who has altered the data, though audit trail table with ip address will be ideal.

3. Hide the navigation pane and ribbon for anyone other than administrator, including office button.

4. User level security is it required to set in every pc where the front end sits or one pc where the data is located.

CAN ANY ONE HELP,

 

[CJ_London]

There are plenty of threads covering these subjects already on this forum - if you look at the bottom of the page you will see a number of links to get you started

 

[srinivasbharat]

thanks, but i will be greatful, if u can give a link, i tried to find a network solution, but could not

 

[CJ_London]

1. Access Login - put 'access vba user login' into your search engine
2. Audit trail - look at the links below for audit trail
3. hide navigation pane - http://www.access-programmers.co.uk/forums/showthread.php?t=115646
4. where to put security - depends on what you want to secure, do you just want to protect the back end - which if it is a .mde you can use user level security see this link http://databases.about.com/od/tutorials/ss/usersecurity.htm. Note this is not available in 2007 and later. For these you have to build your own - again, there are plenty of threads on this subject with this form, but just form this which is a tutorial http://www.599cd.com/site/courselist/seminars/access-security/

 

[srinivasbharat]

thanks CJ_London,
regarding user control i have already implemented it it. below i am describing the setup.
5 pcs having front end and one having both front and back end (my pc) which acts as server.

i hav given privileges/rights for the front end i all the five pcs. and its working just fine, in fact the way i wanted, like to give write rights to certain user to certain form/table etc. which so far i hav not seen in any of the login related posts anywhere.

problem is, the login username and password is being asked for the all the databases in addition to the frontend for which i wanted to give rights. so what will happen if any one of the user decides to create his own dB and he wants to have admin login for his dB and user login for mine?

next problem is anyone can copy the front end, put in a networked pc and will be able to access the server back end dB, since i will not be aware of this copying, and access allows to run the front end, and not user control is implemented in new pc, and he will be able to modify all the data/forms etc. how to overcome this? is there any simple solution, may be at the back end level, to prevent people from login in itself to db, like login only if ip of user is matched?

audit trail, i will have to check, tried allen browne website, seemed little simple, but needs to created two tables for each table and in my case it will create at least 50 tables, so still studying that.

thanks for reply anyway. hope you will give some light on the above issues as well.

 

[CJ_London]

I'm sorry, you have a complex setup so you are going to have to work it out for yourelf, use the links I have provided and look for others

so what will happen if any one of the user decides to create his own dB and he wants to have admin login for his dB and user login for mine?

If I've understood you correctly they will still need your user login to login to your db

and he will be able to modify all the data/forms etc. how to overcome this?

convert fornt end to mde/accde