I have run into a string of Primary Key auto-numbers that change for no reason I can see. Table 'Goals' is associated with Table 'Objectives'. Objectives has 1020 rows and the most recent row is 1020. This morning, users are getting errors when they add new rows to Objectives. When I use Design Table to look at the PK auto-number value it says 954. Obviously, if a new row gets added an error is thrown. This is not the first time this has happened. What could cause a PK value to change? I rebuild the database regularly. Is there any way I can reset the PK value to 1021 (or whatever I need) while users are still active in a compiled v95 database with latest updates.
Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 W- 217-245-9504 F - 217-245-2350 E - [email protected]
