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

How do I overwrite a record in a table with an existing primary key?

P: 10
Hi there,

I have an update query that will insert a record from another table into an empty table.

If I change ie a field in a record i like to overwrite that record in the table. This is not allowed and it says that you are inserting 0 record when the query is run.

How do I solve this?
Jan 3 '08 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,366
Hi there,

I have an update query that will insert a record from another table into an empty table.

If I change ie a field in a record i like to overwrite that record in the table. This is not allowed and it says that you are inserting 0 record when the query is run.

How do I solve this?
I'm not sure I understand. An insert is not an update query but an append query. What table are you talking about when you say "that" table? What does any of this have to do with a primary key? You mention a primary key problem in your title but don't elaborate on it in the post.
Jan 3 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.