Hello...
I have s question which I would be extremly grateful to whosoever helps out in anyway.
FIRST THE SCENARIO
I have a database that has both front ends and a back end. In the front end, the user has the ability to use and Administrative Menu that is password protected in order that the user may change/add/append the data in the back end. (Note the back end is a set of linked tables in the front ends)
AND NOW THE QUESTIONS.
I would like to make the Admin menu Exclusive to a single front end. That is only one user can get click the admin button and if another user clicks the admin button he is informed that Mr. X is using it currently.
My solutions were as follows:
1. everytime someone enters the admin menu a table in the back end is appeneded to and the last and only record in that table is rewritten to reflect the new Admin user and a boolean saying he is in. Now when he returns to the main menu the boolean is set to false. This works perfectly until someone pulls the power plug on the computer that is using the admin menu or he exits the database direcly using the X button on the main access window. Then i have to manually reset the boolean.
2. The table is rewritten every 5 seconds with a datestamp. And if someone needs to use the admin menu it compares "NOW" to the datestamp. if there is a 6 second gap you can get it if not ... it will tell you who is curretly using it. HOWEVER, the computer with the admin menu running uses 178KBytes/sec UP AND DOWN to accomplish this. And i still dont get real time DATA on the BACK END. ie. sometimes I get when other front ends check for the date stamp they just HANG for about 15 secs before they return the error.
Thanks ....
Taha
thamiral@uwo.ca
I have s question which I would be extremly grateful to whosoever helps out in anyway.
FIRST THE SCENARIO
I have a database that has both front ends and a back end. In the front end, the user has the ability to use and Administrative Menu that is password protected in order that the user may change/add/append the data in the back end. (Note the back end is a set of linked tables in the front ends)
AND NOW THE QUESTIONS.
I would like to make the Admin menu Exclusive to a single front end. That is only one user can get click the admin button and if another user clicks the admin button he is informed that Mr. X is using it currently.
My solutions were as follows:
1. everytime someone enters the admin menu a table in the back end is appeneded to and the last and only record in that table is rewritten to reflect the new Admin user and a boolean saying he is in. Now when he returns to the main menu the boolean is set to false. This works perfectly until someone pulls the power plug on the computer that is using the admin menu or he exits the database direcly using the X button on the main access window. Then i have to manually reset the boolean.
2. The table is rewritten every 5 seconds with a datestamp. And if someone needs to use the admin menu it compares "NOW" to the datestamp. if there is a 6 second gap you can get it if not ... it will tell you who is curretly using it. HOWEVER, the computer with the admin menu running uses 178KBytes/sec UP AND DOWN to accomplish this. And i still dont get real time DATA on the BACK END. ie. sometimes I get when other front ends check for the date stamp they just HANG for about 15 secs before they return the error.
Thanks ....
Taha
thamiral@uwo.ca