Timed database
OCR Computing AS and A Level Discussion Board: 2510 - Computing Project: Timed database
Can anyone tell me how to produce a timed database... like a database that has 1 hour timer... and it has to close after 1 hour. And a database that can only be opened once for each user...
Are there any formulae or queries or something?
Please reply me soon.
I am replying in the forum because other people may benefit... or may have better ideas... sharing is a good thing 
some possibilities which you might want to explore...
Timing - my first thoughts...
Every form in the access ( I assume this is what you are using) has an OnTimer event and a timer interval property. (it's just like using a timer control in vb). So here is a possible solution:
Make sure that your main start up form cannot be close (or that when it closes, the whole database closes with it). - this is because the timer only works at form level
set the timer interval to the equivalent of 1 hour in milliseconds.
Write a macro or some code for the onTimer event to close the database. (a message to the user saying that this is about to happen would be nice!)
Opening only once per user...
You might be using Access's security features... (under Tools,Security) in which case there is probably a way to do this in there but I haven't played enough with that feature... (there is a Users and permissions wizard) which will take you through the process.
Alternatively, you may have a table in the database with details of all the users and perhaps their passwords (you can always make the table invisible by using usys in the name). Add a yes/no field in there for currenlty logged on. This method will involve writing some vba code to check for the password and currentlyLoggedOn fields, to set the currentlyLoggedOn field to YES when the user logs on and to NO when the database closes. (this last bit is easier if you set the database to force the user to log off).
REMEMBER:
if you are a student needing this for the project then don't forget to note these problems and how you solved them in your diary so that it will be taken into account in section C(iii)
Hi,
I use the inbuilt security utility of MS-ACCESS XP to encrypt a database.
Tools ----> Security -----> Encrypt/Decrypt Database
-----------> Encrypt database as ........
but the 'encrypted' database is the same as the original one! What have I done wrong?
Can someone advise me please. Thanks in advance
|