ms access - Force user login after x min of inactivity -

-

i have application has 1 login form, 1 main dashboard form, 7/8 sub dashboard forms , many other non-main/dashboard forms.

i implement sort of system, whereby if user has been inactive x minutes, asked login again.

is there way have global function run continuously check every 60 seconds if login required? obvious way using on timer event. many forms have add call each form etc.

is there easier way?

i don't think there easy way this.

first off, have define "user has been inactive x minutes" means. there options:

  1. the access application not focused window x minutes. (drawback: user idling access application on front, never triggering focus loss)
  2. a form not focused x minutes. (drawback: you'd have implement check routine each , every form in application, logging gotfocus and/or lostfocus events verify @ least x minutes form focused. but: user legitimately working x minutes same form never needing change focus nevertheless trigger logout.)
  3. no user interaction occurred (that is, events triggered button clicks , on) x minutes. (drawback: each event handle have add additional code reset x-minutes-timer. you'll need introduce new event handlers naviagtion (see #2, focus loss) don't log off users being active navigating forms.)
  4. ... other methods won't work better either.

there no way without having cope host of new problems.

the better solution set default idle time in backend database, assuming active database server , not access database (or same database forms in).

in latter case don't have dedicated database server challenge rethink why want timeout of login in first place. or, rephrase:

what login in access-only database?

security? there no way can prevent user accessing data in database, independent of them having login or not. remember: access database file on filesystem. user using database has, in fact, access in file. there no such thing user-level security in access (not anymore @ least; , that's best).

you can encrypt whole database (file --> info), can specify 1 password per database, not per user. again: user-level security cannot done in access.

see answer more on security of access databases: https://stackoverflow.com/a/530778/6216216


Comments

Post a Comment

Popular posts from this blog

ios - RestKit 0.20 — CoreData: error: Failed to call designated initializer on NSManagedObject class (again) -

-
this error has shown on many times, seems. prominent answer issue seems restkit 0.20 — coredata: error: failed call designated initializer on nsmanagedobject class however, solution posted doesn't work me. let's start beginning: i want upload file server. want parse response make sure uploaded. if not, try again later. model has boolean variable called nsnumber *senttoserver purpose (in coredata, bool saved nsnumber ) . because don't know whether sending going successful, save entity coredata model first before sending via restkit. when post request successful, server returns json string this: {"id":14,"created":true} notice that, of course, id not set on coredata model yet, both id , created new informations model. here's model: @interface recording : nsmanagedobject @property (nonatomic, retain) nsstring * audiofilepath; @property (nonatomic, retain) nsdate * createdat; @property (nonatomic, retain) nsstring * deviceid; @...
Read more

java - Digest auth with Spring Security using javaconfig -

-
so i'm trying create digest authentication spring following documentation trying translate xml "requirements" in java requirements. let's have xml in docs: <bean id="digestfilter" class= "org.springframework.security.web.authentication.www.digestauthenticationfilter"> <property name="userdetailsservice" ref="jdbcdaoimpl"/> <property name="authenticationentrypoint" ref="digestentrypoint"/> <property name="usercache" ref="usercache"/> </bean> <bean id="digestentrypoint" class= "org.springframework.security.web.authentication.www.digestauthenticationentrypoint"> <property name="realmname" value="contacts realm via digest authentication"/> <property name="key" value="acegi"/> <property name="noncevalidityseconds" value="10"/> </b...
Read more

laravel - PDOException in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) -

-
my .env: app_env=local app_debug=true app_key=myappkey app_url=http://localhost db_connection=mysql db_host=localhost db_port=3306 db_database=gestiontaller db_username=root db_password='root' cache_driver=file session_driver=file queue_driver=sync redis_host=127.0.0.1 redis_password=null redis_port=6379 mail_driver=smtp mail_host=mailtrap.io mail_port=2525 mail_username=null mail_password=null mail_encryption=null i've tried password ", ' , without, restarting server every time. i've tried changing localhost 172.0.0.1. yes, password correct, running mysql -u root -p introducing password root in prompt can go mysql. users table: +------------------+-----------+ | user | host | +------------------+-----------+ | debian-sys-maint | localhost | | mysql.sys | localhost | | root | localhost | | root1 | localhost | +------------------+-----------+ i've added homestead.yaml this: database_port: 3306 ...
Read more