Macro doesn't work on form or Macro timing and locked table

[Mike]

I have a module that imports all filenames in a specified folder into
a table. After this, I have a make-table-query that extracts all
information needed for later processing.
If I acces the import all filenames module and the make table query on
a separate page with buttons (and before doing this having closed the
main form), all works fine.
As soon as I want to run the macro from the main form I get a table
locked error message, although the macro includes a part where I close
tha main form before running the rest of the macro.

Can anyone help me or at least get me on the right track?
I have already tried to put a wait command in, but this didn't work
either.

 

[Mike]

I have a module that imports all filenames in a specified folder into
a table. After this, I have a make-table-query that extracts all
information needed for later processing.
If I acces the import all filenames module and the make table query on
a separate page with buttons (and before doing this having closed the
main form), all works fine.
As soon as I want to run the macro from the main form I get a table
locked error message, although the macro includes a part where I close
tha main form before running the rest of the macro.

Can anyone help me or at least get me on the right track?
I have already tried to put a wait command in, but this didn't work
either.

Sorry for the double post. Original post and additional info see:

http://groups.google.com/group/micr...sue+with+macros&rnum=1&hl=en#ecd1feeae9b06775