On closing DB

[puforee]

I have a DB that has been split. When I open the mdb it also opens the XX_be.mdb (data storage).

I would like the xx_be.mdb to run a query when it closes. Of course the xx_be.mdb is closed when the front end mdb closes.

Is there some event or trigger that recognizes the xx_be.mdb is closing so I can put code against it?

I do not want to run this query from the front end mdb.

Thanks,

 

[randy700]

You could open a form when the db opens, and put code in it's Close event.


Randy

 

[puforee]

Interesting thought. So, when the U/I mdb close, it closes the be_mdb. In so doing, it closes the form that is open in the be_mdb that has the On Close Event code to run a query lets say? (The query is what I want it to do)

Is this the idea?

 

[MazeWorX]

The backend never actually opens. When your front end connects it links to the data in the linked tables. The same way 'compact on close' will never compact a backend db as it has not opened. you would have to open the backend run your query and then close the backend.

What is the purpose of the query?
There may be a better way if we understood the purpose of the query

Thoughts?

HTH << MaZeWorX >> Remember amateurs built the ark - professionals built the Titanic [flush]

 

[lameid]

MazeWorX is on the money. The form in the backend will never open to be run the way Randy700 is saying.

His questions are good too.