Resolving why a Microsoft Access Database is read-only using MapInfo Pro
Product Affected: MapInfo Pro™
Issue
When importing a Microsoft Access Database in to MapInfo Pro, the database is read-only despite the table being editable in Microsoft Access.
Cause
One of the possible causes can be the data type for one or more of the fields. MapInfo Pro only supports up to 254 characters for Character or Text type fields.
Resolution
UPDATED: December 4, 20191 - Open the table in Microsoft Access
2 - Check the columns that are set to the data type of Text and ensure they do not exceed 254 characters in length
3 - Save the table in Access
4 - Create a new connection to the database in MapInfo Pro
5 - The table should now be editable in MapInfo Pro
2 - Check the columns that are set to the data type of Text and ensure they do not exceed 254 characters in length
3 - Save the table in Access
4 - Create a new connection to the database in MapInfo Pro
5 - The table should now be editable in MapInfo Pro
