Linked Tables and Input Masks

T

Tammy Boehme

How can you change an input mask that is in a linked table? A pop-up window
states that you cannot make changes to this table and I have not found a way
to do it. Any suggestions?

--
Tammy Boehme
Programmer I
Department of Physics
Texas A&M University
Work:(979)845-7787
[email protected]
 
V

Van T. Dinh

Didn't you already got a reply stating that you have to modify the source
Table, NOT the linked Table?

This means that you have to open the Back-End database where the Table
resides (as a local Table) and modify it there.
 
T

technolust

You might have to manually make changes to the Input Mask property of
the table.

Use the Linked Table Manager (see TOOLS, DATABASE UTITLIES) to find
the database where this table resides. Open that database in Access.
Click on the Tables tab. Select the table in question. Click the
'Design' button on the Database window. You will find the Input Mask
property under the Field Properties section.
 
Top