Access Not Shutting Down after Execution of a macro

  • Thread starter Thread starter Swannie
  • Start date Start date
S

Swannie

Can anyone help me with this problem.

I have a database which connects to an Oracle db through
an ODBC connection.

The user runs a macro which does a variety of things

1) Opens up a form for the date parameters selection
2) Opens a delete record query query
3) Opens up the query thats extracts data from the Oracle
db
4) Runs another simple macro
5) Gives user message that it has run and finished.

For some reason after the user has extracted the data,
they are unable to close down the database, and need to
use task manager to close it down. When running each of
the steps of the macro individually the database will
still shut down, and if I have stopped the macro running
anything else.

Does anyone know the reason for this, and more importantly
how to fix this problem ?

Thanks

Swannie
 
Post the actual macro's steps. Perhaps some object is persisting and that is
preventing the shutdown of ACCESS.
 
I have already tried each component of the macros
seperately, to see if there way a specific step that was
causing the macro to hang.

I think it may be due to one of two things, either the
ODBC connection is causing the database to "hang" when
closing, or due to the amount of data being transferred,
which is upwards of 50MB, this is causing the windows I/O
buffer to work incorrectly.

Thanks for your post anyway.

Swannie
 
Back
Top