Problem with .mdb to SQL append queries

[Kristina]

I'm trying to run multiple append queries in an Access front end that
append data from tables in a .mdb into tables in SQL Server 2000. My
Access front end has a link to both tables, the .mdb and the SQL
Server. What happens is that I run the first query, and it runs
without problem. When I run the second query, I get an error that
there is a key violation on every record in that table. However, if I
exit my front end application, re-enter it, and run the query, it
executes without problem. Once again, if I run the third query, I get
a key violation error. And if I exit and re-enter the application, it
runs without problem. And on, and on.
Has anyone every experienced this?

[Tom van Stiphout]

On 12 Jan 2005 13:42:21 -0800, "Kristina" <kr**********@gmail.com>
wrote:

That's very unusual. Post your code; perhaps we'll see something that
might cause problems.

BTW, you don't have to run the append queries against the attached
tables. Read up on the SQLPassThrough option.

-Tom.

I'm trying to run multiple append queries in an Access front end that
append data from tables in a .mdb into tables in SQL Server 2000. My
Access front end has a link to both tables, the .mdb and the SQL
Server. What happens is that I run the first query, and it runs
without problem. When I run the second query, I get an error that
there is a key violation on every record in that table. However, if I
exit my front end application, re-enter it, and run the query, it
executes without problem. Once again, if I run the third query, I get
a key violation error. And if I exit and re-enter the application, it
runs without problem. And on, and on.
Has anyone every experienced this?