The utility opens a dialog box that displays all the linked tables in your database.Simply select the check boxes for the ones that you think need to be verified and updated, and then click OK.You can easily update the location information in the table links by using the Linked Table Manager.To use this handy utility, open the database that contains linked tables that you need to relink, and on the External Data tab, in the Import & Link group, click the Linked Table Manager command.
SSN SET [Employee Health].[EMPLOYMENT STATUS] = "NO LONGER EMPLOYED" WHERE ((([Employee Health].[EMPLOYMENT STATUS])="ACTIVE") AND ((active_emp_info. Your Update Query or Your Delete Query Fails If the Query Reads Data from a Linked Text File View products that this article applies to. [HIRE DATE] = rst Link("CONTINUOUS_SERV_De If rst Link. vewwy vewwy curious :-) lndsy This message is larger than the current system limit or the recipient's mailbox is full.
You can still click OK to open the linked table in Design view.
You can open a linked table in Design view to change the Format, Decimal Places, Caption, Description, and Input Mask property settings for any field.
I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.
Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S. No Match Then Msg Box "Could not find " & rst Table. Value Exit Do End If I get the Msg Box, saying that it can't find the first SOCIAL SECURITY # in the Table that contains the records to be changed.