How-to Guides

How to fix MS Access data display

When any of the Departmental databases is redesigned, for example, by adding a new field, Microsoft Access needs to be told to refresh its copy of the database design. If this is not done, instead of seeing the data in the normal way, all that is displayed is "name??", or similar, in each field. To correct this, follow the steps below.


Contact Jeremy Rowntree for more details

1  Open the Linked Table Manager

To do this, from the Tools menu in Access, select Database Utilities, then click on Linked Table Manager.


2  Refresh the linked table list

Click the Select All button, then click OK. After a few moments, a confirmation box should appear. Click OK, then click Close.

Close and reopen the database form and everything should be back to normal. If not, contact IT Support.



Options for this page:

Search All Guides | Search How-to Guides Only | List How-to Guides | Search FAQs Only





Page Last Updated: 30/01/2007 by Jeremy Rowntree





Page Last Updated: 16/02/2017 by Webmaster
© 2006 Department of Biochemistry