Hi Tom,
thank you for reply. It could be a reasonable way to check the calling client, even if it needs more code and change each sql sequence. I'm looking for something more simple and fast, like Windows API: at least checking which client is connected, at the moment, to the server
Bye

>Hi Francesco,
>
>with GETENV([COMPUTERNAME]) and GETENV([USERNAME]) each client-pc can submit it's name and the user's name. To check, which data is being read, I would create a seperate table i.e. currenttasks containing information like
>
>id i (autoinc),
>computername c(20),
>username c(20),
>tablename c(20),
>accesstype i (INSERT=1/DELETE=2/UPDATE=3),
>beginwork t (datetime),
>endwork t (datetime)
>
>Before each sql sequence just call a routine i.e. filltaskstable(1|2|3). The given parameter defines the accesstype.
>
>A second possibility would be, to create triggers for those tables, that you are mostly interested in. However, AFAIK those wouldn't be able to set an endwork field.