Questions

[Zoltan Kovacs]

All,

Please help me in some questions, I will solve in an
engineering-techniciant database.

1. I will limit the usage time of the Access database. How can I limit
the time, without any action of the users. I would like the system is
logging out the non active working user after for example 5 minits.

2. We are working in multilingual factory. How can I change the forms,
reports language acording the login. Now I see the possibility to
create more forms, but it increase the database size. Once couple
years ago,I learned Access first time, I saw a solution, based on a
language table, but I don't remember on.

THX

 

[Alex Dybenko]

Hi Zoltan,

1. I will limit the usage time of the Access database. How can I limit
the time, without any action of the users. I would like the system is
logging out the non active working user after for example 5 minits.

this should be a custom solution. you have to check all user activities
(records entry/form/report open, etc), save it in users table, and on hidden
form run a query on unactive users, then display a message, and after while
quit database

2. We are working in multilingual factory. How can I change the forms,
reports language acording the login. Now I see the possibility to
create more forms, but it increase the database size. Once couple
years ago,I learned Access first time, I saw a solution, based on a
language table, but I don't remember on.

i have one, called translator, you can find it at www.pointltd.com or office
marketplace

HTH

 

[Roger Carlson]

I don't know how you would solve the second, but as for the first... On my
website (see sig below) is a small sample database called
"LogUsersOffNonUse.mdb" which does just that.