how to stop a database

[bigmac]

hi all can you help please , I created a database that uses the "lngEmpName " number to give user permissions , what I need is to be able to disable the running of the database (or main form)and show an error message using vba if I have not logged in for around two weeks is this possible ? if so how and even better a demo would be fantastic.
cheers for looking

 

[Minty]

I would store your last logon time in a local table, then you would need to run an OnTimer event to check every 10 minutes / hour / whatever you need, to check if that time was 2 weeks ago . If it was close the database.

 

[bigmac]

hello minty , thanks for you quick response , one question how do I get it to record when I log on and not other users?

 

[Minty]

If you are in a domain environment you can use an environment variable (a quick Google search will get you there)

 

[Ranman256]

If user login is too old, then:

docmd.quit