Application.Quit

[nvus]

Good Afternoon,

I know there is very nice code to apply to an Access db that can log ALL users out after a specified amount of time. What I'm searching for is to an adaptation of the code that would log off A SPECIFICuser.

There are times when A user has a problem, the IT department needs to be contacted to bump this user off. However, I'm hoping to find alternative to this. Currently I'm working in this direction:

Pull ONLY specific records rather than using the entire rst.
SQL statement to gather all the records of the rst where the yes/no field is True and include the field that has the users login name (2 fields).

Using the SQL statement set the variable (value of the field for user's LoginName)

Using the Variable in a FOR EACH NEXT statement to bump each user off.

application.quit

However, I haven't had any success. With my entire code, I don't get an error, but the user isn't logged out either. I suspect this has something to do with the .ldb file.

Does anyone know of any such code or ability.

 

[Uncle Gizmo]

I've seen this done somewhere, can't remember who what where when though!

The way I understood it, you have a hidden form in the front end database for all your users, this has a timer event that triggers a check of a particular table on the back end database. the administrator has access to this backend table and sets a boolean field that triggers the front end database to shut itself down after giving a suitable warning.

I don't think it was quite that straightforward, you need to write some code to close any open forms so that no data is lost.

 

[RuralGuy]

Jeff Conrad has a few links you could try.