Autonumber Conflicts

For best results: this site requires that cookies be enabled for proper operation - see Legal Page for more info

Starting December 1, 2006 Techsinfo.be will no longer be available please update your links to http://techinfo.e2uhosting.net Thank you

Select Any of These

AVOID AUTONUMBER CONFLICTS

One way to copy or move data from one table to another is to run an Append query. However, if both tables contain AutoNumber fields, you could end up with duplicate AutoNumber values in the target table (the table to which you're appending data). If you include the source table's AutoNumber field in the query, Access copies those values to the target table during the Append query process. If those values already exist in the target table, you'll end up with duplicate values in your AutoNumber field.

If your source table doesn't have any relationships based on the AutoNumber field, you can avoid this problem. Simply delete the AutoNumber field in the source table, then append it. The target table creates a new AutoNumber value for each of the appended records. Once you've appended the records, you can add another AutoNumber field to the source table. Just be sure there are no indexes set in your source table before deleting the AutoNumber field. An index might cause your records to sort again, and you'll have a difficult time reassigning the appropriate AutoNumber values to each record. In addition, you won't be able to use the newly numbered records in the target table in any expressions or functions that rely on the source table's original values

LAST UPDATED: Friday, 19. May 2006 23:16:10 +0200

Questions?

Just Check out some of our sponsors

Shop at BestPrices.Com!