If you want to make modifications to an Excel file that is linked to an Access database,what must be true?
A) Access and Excel must be open at the same time
B) you need to use the Import Spreadsheet Wizard
C) the datasheet must be displaying in Access
D) the linked table must not be open in Access when you open the Excel file

Question

Quizplus · Accepted Answer

Modifying an Excel file that is linked to an Access database does not require Access and Excel to be open simultaneously, the use of the Import Spreadsheet Wizard, or the datasheet to be displayed in Access. However, the linked table in Access should not be open when you open the Excel file to ensure that the Excel file can be edited without conflict or locking issues. This is because Access locks the table for editing if it is open, which could prevent changes in the Excel file from being correctly reflected or saved.

If You Want to Make Modifications to an Excel File