Phucon
Is it possible that 8 records violated primary keys because they were already in the table? I guess the only way to check if that happened would be to delete all 138 records and run the query again.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "saigonf7q5" wrote:
>
> The result of my query has a total of 138 rows. I ran the INSERT INTO query to insert the query result (138 rows) into a table.
>
> The RECORDSAFFECTED shows 130 records were added… Does mean 130 records have actually been added to the table? Or 138? I checked the table, in fact there were 138 rows were added. Why Access displays a message box saying 130 records were added? What happens to the other 8? Is it because there's error?
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar