Record-Locking Information (*.LDB)

[Treason]

I maintain a BE/FE database with approx. 20 users. I have code set up in my front-end to kick users off whenever I wish. Yet, after I kick users from the FE, I still cannot design existing tables in the BE. It still shows thier machine name in the ldb file! Even after the suspect machine is restarted!

This kinda loses the whole point in kicking out users if Access thinks these users still exist. I guess the question is, Is there a default Time-Out interval when the names from the ldb file will be wiped? Furthermore, Can I control it?

Thanks for any and all info...

 

[ghudson]

Are you sure that everybodies frontend is being closed?

Does everybody have the proper rights to delete a file where the backend is located? If not, the .ldb file will not disapear when the last user closes the db.

You also have to close the db or else the .ldb file will not be deleted. Once everybody is out, you should open the backend as "exclusive" to prevent anybody from opening their front end while you are still in the backend.

HTH

 

[Treason]

well... i am pretty confident in my code. After five minutes everyone will be booted.

Is there any time out interval?

 

[Crampton]

Treason

Sorry to ask this but i have been searching high and low for some code or way of getting users off the database without ringing them all up and telling them to get off etc !!

Is there a way to do this.

Sorry to butt in on your original question.

Thanks.

 

[Treason]

It basically uses a hidden form with a timer that is bound to a yes/no field. That is it at it's simpliest. My code has a little more features but you get the idea...

Roger's Code Library has a neat sample you can use:

Roger's Code Library

it's called LogUsersOff.mdb

About my previous post. I logged off my users last night and waited about two hours but it still showed people loggin in that weren't. This morning it must of realized these users were not online and it erased the *.ldb It took from 3 to 12 hours for access to realize this. Does anyone know the default logoff Time when access erases the ldb? And can I set it?

thanks for any info

 

[Crampton]

Thanks very much Treason, very helpful info

Thanks again