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

 

[Pat Hartman]

Using the Access application "x" to close Access does NOT damage the db. Access completes any pending updates and closes all open forms BEFORE it closes the db.

If you are experiencing a corruption problem and the db is not already split, split it. Give the users separate copies of the fe and let them share the be on the server. This almost always cures any corruption issues. If you still have problems it is likely that the users are leaving the db open when not using it and they are experiencing either a network timeout or perhaps a power saving hardware feature that shuts down the hard drive is causing a network disconnect.

 

[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.