Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 21st, 2005, 03:20 PM
Friend of Wrox
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default Append Query to Table !

Hi experts !
I've to append a qry to a tb and i need an ID autonumber type
column on the tb. Should i have an extra column on the qry too?
Has someone an answer to how should i make it work? It's not
a difficult task but i've been working for hours on a program
and when i thought it was to be completed something happened
because of an PK less on the tb. At least is my guess.
Regards Penta.

Old February 21st, 2005, 08:31 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts

Hi Penta,

No,the append query shouldn't include the ID column. Just make sure you have implemented it in the table you are appending records to. The assignment of AutoNumber/PrimaryKey values will be handled at the table level as each new record is appended to the new table.



Old February 23rd, 2005, 03:53 PM
Friend of Wrox
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts

Sorry for the delay!
I've been out of the site. I've tried to append the qry to the Tb leaving
the autonumber column of the qry out of the columns to be appended. I've
had an error message run-time 3022. I've tried to leave the column on
the append qry and i've tried to append to the Tb which has an autonumber
column as a PK.I've had error message run-time 3346. What should i do
to have an autonumber PK column on the Tb.We must remember that the append action should be done several times with different records and the autonumber column of the qry will always show same values for each append action.
Regards P.

Old February 24th, 2005, 04:24 PM
Friend of Wrox
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks to u all !
I am surprised to see that now everything is working OK. That is: the append
qry appends to the Tb which has an PK column working as it should. In plus
the problem it was supposed to be a PK less Tb was nothing less than
an error during the design of my report.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Append Query bright_mulenga Access 1 January 3rd, 2007 01:33 PM
Append Query Cybersurfer Access 1 February 13th, 2006 01:02 PM
copy and append records from table-A to table B bhunter Access 6 March 9th, 2004 02:02 PM
Append Records From One Table to Another Table twsinc Access VBA 4 February 29th, 2004 03:04 PM
append query stoneman Access 2 November 12th, 2003 09:17 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.