MSAccess Missing Column After Relinking Table

Question

I am trying to add a pull-down combo box to a form in MSAccess. The strange part is that the (email) column is missing. I have performed the following checks/actions

1. Validated the SQL table (SUP_CONTACTS) has the desired column
2. Validated MS Access has the linked table (SUP_CONTACTS) linked and contained the desired column.
3. Deleted and relinked the table (several times), and repaired the data base (several times)

No luck, and not sure what is causing this defect.

Any help is greatly appreciated. Thanks.

FIG A: SQL Table (SUP_CONTACTS) with email column

FIG B: MSAccess Linked Table (SUP_CONTACTS) with email column

FIG C: Combobox missing email column

Answer 1

I would try changing the data type from long text to short text. Short text allows 255 characters which is more than enough for an email address. If this gives you an error for data type mismatch then you are going to have to get creative. Here’s one way to handle an error from the date type mismatch. Create a new local table containing only the email address from the linked table, change the data type to short text and include that field in your combo box. The downside of this is that you’ll need to repeat this process whenever you have to refresh the emails. But there are ways to streamline such a task.