-
1
- #1
I have a database which uses the startup options to launch a logon box (Simple box, Username and password). The code behind the box checks the entered detail against the Users table to see if the username and/or password exists. If the user exists then the Main Menu is displayed. This works fine. <br><br>If the Username and/or password doesn't exist then I use a global variable to count up to 3 attempts before the database closes using the [Red]Docmd.Runcommand acCmdExit[/Red] statement.<br><br>All Recordset and other objects are closed and set to nothing before the code is exited, for any reason.<br><br>If I close the database, for whatever reason, by whatever method, I find that there are multiple instances of MSACCESS still running in the background.<br><br>Does anyone know how to stop this happening?<br><br>Cheers.<br>