This is bulls**t

[Stapes]

Hi

I got this from Microsoft Office website:-

http://office.microsoft.com/en-us/access/HA011860631033.aspx#4

Let Access generate the AutoNumber field automatically in the
destination table. To do this, do not include the AutoNumber field in
the append query. If you do not include the AutoNumber field as part
of the append query, it is generated automatically in the destination
table. In the preceding example, the ID column is an AutoNumber field
and is not part of the append query. As a result, the ID column is
generated automatically in the tblCustomers table.

This is blatantly wrong.

It simply does not work.

Stapes

 

[Stefan Hoffmann]

hi Stapes,

Let Access generate the AutoNumber field automatically in the
destination table. To do this, do not include the AutoNumber field in
the append query.
This is blatantly wrong.

No, under normal circumstances, this is true.

It simply does not work.

First of all, repair and compact your database.

What excatly does not work?


mfG
--> stefan <--

 

[Stapes]

hi Stapes,


No, under normal circumstances, this is true.


First of all, repair and compact your database.

What excatly does not work?

mfG
--> stefan <--

Same as the preceding post. Compact and repair didn't slove the
problem either.

 

[Douglas J. Steele]

As Stefan asked, please explain what "does not work". Certainly what that
article is describing has worked in Access since Version 1.

 

[Stapes]

As Stefan asked, please explain what "does not work". Certainly what that
article is describing has worked in Access since Version 1.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)










- Show quoted text -

INSERT INTO TM_Courses ( COURSE_NO, COURSE, FK_PROVIDER )
SELECT [Price List _ pjk_aug07 Without Matching TM_Courses].[Course
Code], [Price List _ pjk_aug07 Without Matching TM_Courses].[Course
Name], [Price List _ pjk_aug07 Without Matching TM_Courses].Provider
FROM [Price List _ pjk_aug07 Without Matching TM_Courses];

This does not work. It keeps giving me the message "didn't add 469
records due to key violations".

I am not touching the key field - it is an autonumber field and is
supposed to generate its own.

Stapes

 

[Baz]

It says "key violations", not "primary key violations". You probably have a
foreign key problem i.e. you are violating some relationship defined for the
table.

 

[Stapes]

As Stefan asked, please explain what "does not work". Certainly what that
article is describing has worked in Access since Version 1.

- Show quoted text -

INSERT INTO TM_Courses ( COURSE_NO, COURSE, FK_PROVIDER )
SELECT [Price List _ pjk_aug07 Without Matching TM_Courses].[Course
Code], [Price List _ pjk_aug07 Without Matching TM_Courses].[Course
Name], [Price List _ pjk_aug07 Without Matching TM_Courses].Provider
FROM [Price List _ pjk_aug07 Without Matching TM_Courses];

This does not work. It keeps giving me the message "didn't add 469
records due to key violations".

I am not touching the key field - it is an autonumber field and is
supposed to generate its own.

Stapes- Hide quoted text -

- Show quoted text -

I think I found the problem. There is another Foreign Key in the table
I didn't prime. Eventually I deleted all the relationships until I got
it working.

 

[Guest]

Maybe you shouldn't create a message with such a provocative title?

--
www.ae911truth.org

As Stefan asked, please explain what "does not work". Certainly what that
article is describing has worked in Access since Version 1.

I got this from Microsoft Office website:-

Let Access generate the AutoNumber field automatically in the
destination table. To do this, do not include the AutoNumber field in
the append query. If you do not include the AutoNumber field as part
of the append query, it is generated automatically in the destination
table. In the preceding example, the ID column is an AutoNumber field
and is not part of the append query. As a result, the ID column is
generated automatically in the tblCustomers table.

This is blatantly wrong.

It simply does not work.

Stapes- Hide quoted text -

- Show quoted text -

INSERT INTO TM_Courses ( COURSE_NO, COURSE, FK_PROVIDER )
SELECT [Price List _ pjk_aug07 Without Matching TM_Courses].[Course
Code], [Price List _ pjk_aug07 Without Matching TM_Courses].[Course
Name], [Price List _ pjk_aug07 Without Matching TM_Courses].Provider
FROM [Price List _ pjk_aug07 Without Matching TM_Courses];

This does not work. It keeps giving me the message "didn't add 469
records due to key violations".

I am not touching the key field - it is an autonumber field and is
supposed to generate its own.

Stapes- Hide quoted text -

- Show quoted text -

I think I found the problem. There is another Foreign Key in the table
I didn't prime. Eventually I deleted all the relationships until I got
it working.

 

[Stapes]

Maybe you shouldn't create a message with such a provocative title?

--www.ae911truth.org

On 27 Jul, 11:01, "Douglas J. Steele"
As Stefan asked, please explain what "does not work". Certainly what that
article is describing has worked in Access since Version 1.
--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

Hi
I got this from Microsoft Office website:-
http://office.microsoft.com/en-us/access/HA011860631033.aspx#4
Let Access generate the AutoNumber field automatically in the
destination table. To do this, do not include the AutoNumber field in
the append query. If you do not include the AutoNumber field as part
of the append query, it is generated automatically in the destination
table. In the preceding example, the ID column is an AutoNumber field
and is not part of the append query. As a result, the ID column is
generated automatically in the tblCustomers table.
This is blatantly wrong.
It simply does not work.
Stapes- Hide quoted text -
- Show quoted text -
INSERT INTO TM_Courses ( COURSE_NO, COURSE, FK_PROVIDER )
SELECT [Price List _ pjk_aug07 Without Matching TM_Courses].[Course
Code], [Price List _ pjk_aug07 Without Matching TM_Courses].[Course
Name], [Price List _ pjk_aug07 Without Matching TM_Courses].Provider
FROM [Price List _ pjk_aug07 Without Matching TM_Courses];
This does not work. It keeps giving me the message "didn't add 469
records due to key violations".
I am not touching the key field - it is an autonumber field and is
supposed to generate its own.
Stapes- Hide quoted text -
- Show quoted text -

I think I found the problem. There is another Foreign Key in the table
I didn't prime. Eventually I deleted all the relationships until I got
it working.- Hide quoted text -

- Show quoted text -

Yeah - maybe - I liked your website link though!

 

[Tony Toews [MVP]]

I think I found the problem. There is another Foreign Key in the table
I didn't prime. Eventually I deleted all the relationships until I got
it working.

Hopefully you've added back all those relationships?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

I saw the title, and I thought 'an aussie?
with aussie rather than north american vocabulary?

Oh well. Around here, those words are harmless except when used in mixed
age-groups.

(david)

 

[Larry Linson]

Maybe you shouldn't create a message with
such a provocative title?

Some years ago, before the Internet and newsgroups were commonly available,
I answered questions on a company's internal network. Occasionally, I would
respond to someone who thought they were getting everyone's attention by
beginning with a disparaging title or remark about the product.

My typical response to them might be, "You know we participate here because
we use and like <product name>, yet you come here and the first thing you do
is tell us, 'Your baby's ugly." Then you expect us to solve your problem for
you -- even when the ugliness is something for which you are responsible.
Maybe next time, you'd get quicker, and more pleasant answers if you start
your post a little less dramatically."

Polite and pleasant are underutilized but not overrated qualities.

Larry Linson
Microsoft Access MVP