Question Multi-user logging system

[kubih]

Hi everybody,

I have a complete database with tables, queries forms and reports. Now I have no idea how to do the logging system. I'm looking for a solution for multi-users with different priviliges e.g
admin (full priviliges), teachers (read/write some tables etc), students (read/write some other tables etc).

Can anyone know how to do this? I work with Office 2007 edition.

 

[jdraw]

Hi everybody,

I have a complete database with tables, queries forms and reports. Now I have no idea how to do the logging system. I'm looking for a solution for multi-users with different priviliges e.g
admin (full priviliges), teachers (read/write some tables etc), students (read/write some other tables etc).

Can anyone know how to do this? I work with Office 2007 edition.

Have you split your database?

http://support.microsoft.com/kb/162522
http://support.microsoft.com/kb/304932

Here's a link to logger routine _ I've never used it but it may be useful to you.
http://log4vba.everage.ca/