Prev: Access query duplicates the table records
Next: DateDiff function throwing error in Where clause
From: quinto via AccessMonster.com on 2 May 2010 09:03
I am trying to add information to a table with an append query and that works
fine since I duplicated the table. The information comes from a linked XLS
sheet, I need to delete the information and replace it every day. When I
created a delete query it works fine but when I try to add the information
again using the append query it does not work unless I open the query in
design view, save it and run it.
I have dozens of other queries doing the same and they all work fine.
What am I doing wrong? I looks like I am getting a 3349 error but why does it
work once and then when I delete the information it does not work anymore?

Thanks

--
Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: Access query duplicates the table records
Next: DateDiff function throwing error in Where clause