Saving some data on local user

[Roy Goldhammer]

Hello there

My client is going to have an adp project.

He asked to do a machanizem that if the user is not using the application
for an hour the allplication is being closed.

On mdb i solved it by using local value of the last time the user used the
program.

How can i do some thing like this on sql server?

 

[Vadim Rapp]

RG> I use the timer on MDB to do this. The problem is
RG> saving the last time the user used the database.
RG> For this i need to keep on the client this data.

"used the database" is too broad definition. If your purpose is only in closing
the ADP, then I would establish a timer, and programmatically reset it with any
operation within the ADP. Depends on the size and number of such operations of
course... but remember, the database can be accessed not only by this ADP, and
if this is about some billing for the usage, the client will likely soon come
up with an alternative way to work with your database; a server-based solution
exists in the land of sql server audit.

Vadim


RG> Can you help me on it?

RG> message
RG> RG>>> He asked to do a machanizem that if the user is
RG>>> not using the application for an hour the
RG>>> allplication is being closed.
RG>>
RG>>> How can i do some thing like this on sql
RG>>> server?
RG>>
RG>> Do you want to close the adp or sql server?
RG>>
RG>> For the adp, it's probably easy using form's
RG>> timer. ----------------------------------- Vadim
RG>> Rapp Consulting SQL, Access, VB
RG>> Solutions 847-685-9073 www.vadimrapp.com

 

[Roy Goldhammer]

Thankes Vadim

I use the timer on MDB to do this. The problem is saving the last time the
user used the database. For this i need to keep on the client this data.

Can you help me on it?