Access forms on network

[rizunb]

Hi
I have few access forms that I will put on network drive for people to be able to access them from there computers
Now what I need to know is that Is there any way of knowing programatically that more than 1 person is using that application at the same time.

 

[MikeTompkins]

Rizunb - What version of Access are you using? MS has KB for this task for 2000 & XP.
KB285822 Access xp Code

http://support.microsoft.com/default.aspx?scid=kb;EN-US;285822

For 2000 -

http://support.microsoft.com/default.aspx?scid=kb;EN-US;198755

HTH - Michael

 

[rizunb]

Thanks Mike
I am using access 2002 and i got the code from the website u sended me, but when I am running that code its giving me error on

cn.openschema

Now do i have to add a library from refrences or ?

Help me out here
Thanks

 

[GingerR]

i dont know what that code does, but i have a userlog (table) i keep for all of my databases. when they open the db, their windows logon ID is stored with the date/time they've opened it. when they close the db, the date/time they close is logged. i always know who is in which database.