Troubleshoot exchanging data between Excel and Access

Microsoft Office Excel 2003

Show All Show All

Troubleshoot exchanging data between Excel and Access

If the View MS Access Form or View MS Access Report button on your worksheet doesn't work, try the following:

  • Locate the Microsoft Access database    The database that contains the form or report may have been moved. In the Create Microsoft Access Form or Create Microsoft Access Report dialog box, click Browse to find the Access .mdb file. If you created a new database for the form, the .mdb file should have the same name as the workbook file.

  • Check whether the form or report was deleted    Microsoft Excel allows you to have only one Access form and one Access report for each worksheet range. If you create a new form or report after deleting the existing form or report from the database, a second View MS Access Form or View MS Access Report button is added to the worksheet. You can delete the first button that no longer works by holding down the CTRL key, clicking the button, and then pressing DELETE.

  • Check whether the workbook was renamed or moved    If you rename or move the workbook file, the button no longer works. You can restore the original name of the workbook file by changing the file name back to the name it had when you created the form or report, and then moving the file back to the folder it was in when you created the form or report.

  • Unprotect the worksheet if it's protected    On the Tools menu, point to Protection, and click Unprotect Sheet. Remember to protect the worksheet when you are finished with it.

  • Check the names of the Access table and form or report    The name of the table, form, or report for the Excel range in the Access database may have been changed. To restore the name, click the name of the table, form, or report in the database window two times, and then type the correct name. The name must be in the following form:

    workbookname_sheetname_List

    Underscores are used for any spaces in the workbook or worksheet names. For example, if your range is on Sheet 1 in workbook Office Supplies, the table, form, or report should be named Office_Supplies_Sheet_1_List. If your Excel range is a named range, this name is used instead of List.