Problem description:

AC97 databases with linked autonumbered primary key tables fail to populate the autonumber field correctly after conversion to AC2000.

Environment: MS ACCESS 2000 with MSJET 4.0 SP6 running on WINDOWS 2000 PROFESSIONAL SP3

Steps to reproduce behaviour:

1) Create d1.mdb in Access 97
2) Create table t1 in d1.mdb with 2 fields: id (long integer, not indexed!), val (long integer, not indexed!)
3) Create d2.mdb in Access 97
4) Create table t2 in d2.mdb with 2 fields: id (autonumber, primary key), val (long integer, not indexed!)
5) In d1.mdb, link t2 from d2.mdb as t2
6) In d1.mdb, create an append query with the following sql statement: INSERT INTO t2 (id, val) SELECT t1.id, t1.val FROM t1;
7) Compact both databases in AC97
8) Convert both databases using AC2000 conversion utility (Tools->Database Utilities->Convert Databse->To Current Version of Access)
9) Open d1.mdb in AC2000
10) Open table t1 and type the following into id field (8 records will be created)
8
10
2
3
5
7
9
1
11) Close table t1
12) Run query q1
13) Open table t2 (8 records should be present)

EXPECTED BEHAVIOUR WHEN TYPING A VALUE in val field IN A NEW RECORD:
id field gets populated with 11.
ACTUAL BEHAVIOUR WHEN TYPING A VALUE in val field IN A NEW RECORD:
id field gets populated with 2, thus creating a duplicate primary key value
TEMPORARY WORKAROUND
Change sql statement of query q1 to: INSERT INTO t2 (id, val) SELECT t1.id, t1.val FROM t1 order by t1.id asc;Problem description:

AC97 databases with linked autonumbered primary key tables fail to populate the autonumber field correctly after conversion to AC2000.

Environment: MS ACCESS 2000 with MSJET 4.0 SP6 running on WINDOWS 2000 PROFESSIONAL SP3

Steps to reproduce behaviour:

1) Create d1.mdb in Access 97
2) Create table t1 in d1.mdb with 2 fields: id (long integer, not indexed!), val (long integer, not indexed!)
3) Create d2.mdb in Access 97
4) Create table t2 in d2.mdb with 2 fields: id (autonumber, primary key), val (long integer, not indexed!)
5) In d1.mdb, link t2 from d2.mdb as t2
6) In d1.mdb, create an append query with the following sql statement: INSERT INTO t2 (id, val) SELECT t1.id, t1.val FROM t1;
7) Compact both databases in AC97
8) Convert both databases using AC2000 conversion utility (Tools->Database Utilities->Convert Databse->To Current Version of Access)
9) Open d1.mdb in AC2000
10) Open table t1 and type the following into id field (8 records will be created)
8
10
2
3
5
7
9
1
11) Close table t1
12) Run query q1
13) Open table t2 (8 records should be present)

EXPECTED BEHAVIOUR WHEN TYPING A VALUE in val field IN A NEW RECORD:
id field gets populated with 11.
ACTUAL BEHAVIOUR WHEN TYPING A VALUE in val field IN A NEW RECORD:
id field gets populated with 2, thus creating a duplicate primary key value
TEMPORARY WORKAROUND
Change sql statement of query q1 to: INSERT INTO t2 (id, val) SELECT t1.id, t1.val FROM t1 order by t1.id asc;