Adjusting field properties
Before you use the upsized table, you must make a few manual adjustments:
- Set the primary key: You need to set the primary key. Select the ID field and check the Primary Key box.
- Set Auto Increment for the ID field: You need to tick the Auto Increment (AI) option for the primary key ID field. The Access ID values will have been exported. The AI numbering will start from the next available number.
- Set the indexes: You will need to set any indexes that were in the Access table.
- Yes/no fields become bitfields: Access will work well with this; however, you must set a default value of either 0 or 1, and usually, it will be 0 (false). Access has a quirky bug where it will generate an error – usually a write conflict error if the record has a bitfield with a NULL value. You will also need to ensure there are no NULL values in any bitfields in MySQL, which is what causes the error. Access does not like NULL values in bitfields. You can...
