Access re-opens itself

[Lucious]

When I close Access while running a particular database, Access reopens itself. When I then close that instance of Access another instance opens. In order to close Access I have to kill the process (ctrl, alt, dlt). This problem only occurs for one particular database. Any ideas?

[Jen0dorf]

HI

How are you closing the Database? from a form or from the main ribbon Bar.

If from the main ribbon bar do you have any forms open?

My method of diags would be

1. Take a copy of your database

2.Using that copy compact and repair - see if that works

3. Delete the queries, reports forms one at a time testing each time until the fault dissapears.

4 Create a table one field and save it.

5. Delete all your other tables one at a time. -Test

If after all that you still have the issue then I suspect a windows issue but I'm sure others will contribute solutions

HTH

Ian

[Micron]

More info - are you saying it is the same db that 'reopens' or Access just opens to the main application window where you have to select a db to open (and your db is no longer visible)? And, when this happens, you see how many Access instances being reported in the Windows tray?

[Lucious]

Access just opens to the main application window where I have to select a db to open (and my db is no longer visible). Only one instance is being reported in the Windows tray. I believe I have tracked down the problem to the only "local" table (the rest are linked). The problem only occurs after data has been written to that table. Very very weird.

[Lucious]

Access just opens to the main application window where I have to select a db to open (and my db is no longer visible). Only one instance is being reported in the Windows tray. I believe I have tracked down the problem to the only "local" table (the rest are linked). The problem only occurs after data has been written to that table. Very very weird.

[Micron]

My guess is that in code, a created object is still active (e.g. a recordset was created but not closed and the object was not destroyed).
Memory space allocated to an object should be reclaimed by setting all objects to Nothing, and in the case of recordsets, closing them first - before the procedure ends. If you have an error handling routine in the procedure, your code should always be structured in such a way as to do this even if it errors out. Check if you have any created objects that have not been dealt with before the end of the procedure or call to Quit Access.
The fact that the table is local should not matter.