Table of contents
Collapse the table of content
Expand the table of content

You cannot add a second Replication ID AutoNumber field to a table. (Error 3486)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Applies to: Access 2013 | Access 2016

The table you are attempting to change already has one field that uses the Replication ID AutoNumber (or GUID) data type. If you are attempting to create a second Replication ID field to serve as a foreign key, use the Number data type instead of the AutoNumber data type.

Access for developers forum on MSDN
Access help on
Access help on
Search for specific Access error codes on Bing
Access forums on UtterAccess
Access wiki on UtterAcess
Access developer and VBA programming help center (FMS)
Access posts on StackOverflow

© 2018 Microsoft