Access System Tables. Number of characters in a Short Text field. Linked - stored inside external file including Access Excel dBase You can query system table MSysObjects to get information about each user table in Access database.
Microsoft Access supports tables of different types. Now I would like marie to be able to perform this query. Number of characters in a Long Text field.
Then click on the OK button.
Then click on the OK button. Beginning in Access 2013 Text fields are now called Short Text fields. Specific column information is stored in the COLUMNS table. They are maintained by Microsoft Access itself and are hidden to normal users by default.