• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

AutoNumber Starting Value Errors

Q1: When I try to execute the append query that provides the starting value minus 1 to my table structure, I get an error message.
You have constraints on the fields of your destination table that don't allow Null values or empty strings in fields. Open your destination table in Design mode, and make sure the Required property of each field is set to No and that the Allow Zero Length property of each field of the Text data type is set to Yes. Also, make sure your destination table doesn't specify a primary key field.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint