Log Users in Access

[Guest]

Dear Messrs

Is there any way to log each user created by mdw file of a secured MS Access
database (mdb) who is currently log in or used the application. That is the
users created in secured file (mdw) of MS Access application.

 

['69 Camaro]

Hi, Ali.

Is there any way to log each user created by mdw file of a secured MS
Access
database (mdb) who is currently log in or used the application.

Yes. Follow the advice given for how to "Log Each User's Session" on the
following Web page:

http://www.access.qbuilt.com/html/session_logs.html

However, that example is for unsecured databases, so replace the
fOSUserName( ) user-defined function with the built-in CurrentUser( )
function, which will return the User ID that was used to sign into the
secured database application.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[aaron.kempf]

of course if you used sprocs; this might be a whole lot easier

for example; what happens to your app when someone chooses to disable
VBA code??

sprocs could still log everything; because by definition; a sproc can
do multiple things-- one sql call can do 10 things sequentially for
example

with Access queries you need to write CODE to do this


Access Data Projects are a completely superior solution in all manners