Who and where opened the database?

[nagyf]

Gentle List Members:

I want to log who and where opened the database.
We have a network SERVER,PC1 ... PC5.
Which is the object and the property containing
1) the identifier of the current computer,
2) the Windows NT user and domain name,
3) the workgroup filename,
4) the user name of the workgroup?

I have a workaround to question 1):
Shell "vol C:>vol.tmp"
Open "vol.tmp" For Input As #1"
Input#1,Vol1
Input#1,Vol2
Close#1
This way I can read the volume label.

Regards Ferenc Nagy
|\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New!
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- 1525 Bp. POB 77. Tel. 36-1)-392-2550
| \| |

http://alpha0.iki.kfki.hu/~nagyf

`-' ' `-' "The goal of the life is the struggle itself"

 

[x3ja]

I think there's something on that in the Acess Security FAQ from MS:

http://support.microsoft.com/support/Access/Content/SECFAQ.asp

Never used it myself, but it's worth a try.

Alex