Block Access Exit Button

[Traden]

Hi out there,

i have a problem. I want to block or hide just the default Access exit button (z in the upper corner) because some users use that one before logging out and that causes damange to the DB and it needed to be repaierd, but therefore everybody needs to log off..

so any idea how i could block or hide that button that the unsers could only exit through my button?

thx

 

[Autoeng]

Try this...

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=5077&highlight=hide+X+button

 

[Mile-O]

And another: click here

 

[DJN]

Try this. First of all, define a public variable as boolean. Say CantClose
Second, create an unbound form. I name my form as frmHidden
Third, in the unload event enter this code:- If Not CantClose Then Cancel = True
An lastly, add an action to open the frmHidden to your AutoExec. The Window Mode should be Hidden.

David

 

[Traden]

thanks guys! I tried searching but maybe the keywords i searched were not the right ones

 

[Traden]

Pat, thanks for your hint. My DB has about 6-8 users. It is not yet split and located on a networkdrive. The problem is that is it sometimes corrupt. I am not that expert access user, so how would you suggest to split the CB?

Thanks

 

[Mile-O]

Create a separate database and import the tables from your current database - this is your backend. Put this somewhere on your server where all users can get access to it.

Remove the tables from your current database and link to the tables in the backend database. This is your frontend.

Give each user a copy of the frontend.