I am using MS Access 2003.
My problem is that I keep receiving an error when running an append query on an empty table. The same queries run fine if there is already at least one record in the table.
Does anyone else know that problem? Is this an MS Access bug? Any ideas how to solve that problem?
Thanks to everybody!!
@teddy: the error doesn't depend on the query. I receive it with every insert into statment.
THe error just says: Micorosoft Access is about to append 0 rows.
However if there is at least one record in the table the query works fine