Append Query

[Ryan Tisserand]

Does an append query need exclusive rights to the destination table to write
to it, or can the destination table be in use?

 

[John W. Vinson]

Does an append query need exclusive rights to the destination table to write
to it, or can the destination table be in use?

It can be in use.

John W. Vinson [MVP]

 

[Ryan Tisserand]

Thank you for your response, you saved me alot of testing time.