By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,346 Members | 2,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,346 IT Pros & Developers. It's quick & easy.

Problem with .mdb to SQL append queries

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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?


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.