autonumbers

[Sharon]

have 2 db with autonumbers, when i append a record from 1 to other, it now
changes the autonumber to 1+ the number from record appended. in 2003, i
could append and then when i added a new record, it gave me the correct
number.

 

[Jerry Whittle]

If you are attempting to have sequential autonumbers, you will be
disappointed. Autonumbers are only guarenteed to be unique and that's if they
are also the primary key field. Nothing more. Nothing less.

 

[Jeff Boyce]

Sharon

As Jerry points out, Access Autonumbers are intended to provide unique row
identifiers.

Why are you trying to append a record from one db (?table) to another
(?table)?

Are you talking about separate databases, or separate tables?

What will having a record from db/table1 in db/table2 allow you to do?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[De Jager]

Sharon

As Jerry points out, Access Autonumbers are intended to provide unique row
identifiers.

Why are you trying to append a record from one db (?table) to another
(?table)?

Are you talking about separate databases, or separate tables?

What will having a record from db/table1 in db/table2 allow you to do?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.