Hi,

I am trying to append a set of records to a table but when I try a get
the following error:

"Run Time 3008"  -  "The table "twtext2" is already opened exclusively
by another user, or it is already open through the user interface and
cannot be manipulated programmatically"

I have tried using

      DoCmd.Close acTable, "twtext2", acSaveYes
      DoEvents
      DoCmd.OpenQuery
"get_current_batch_to_append_to_twtext2_from_all_Is", acViewNormal

but I still get the error.  Any ideas would be great.


Many thanks

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.