You receive an error message when you try to use the Access Links Add-in for Excel to Create a New Access Database (827320)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 2002
- Microsoft Excel 97 for Windows
- Microsoft Office 2000
- Microsoft Office XP
SYMPTOMSWhen you try to use the Access Links Add-in for Microsoft
Excel to create a new Access database, you may receive the following error
message: The Microsoft Jet database engine could not find
the object 'Sheet1$address'. Make sure the object
exists and that you spell its name and the path name correctly. where
Sheet1$address is the name of the
spreadsheet. CAUSEThis problem occurs after you install Microsoft Jet 4.0
Service Pack 6 (SP6). RESOLUTIONTo resolve this problem, obtain Microsoft Office OneNote 2003 Service Pack 1. For additional information, click the following article number to view the article in the Microsoft Knowledge Base: 842774Description of OneNote 2003 Service Pack 1
To resolve this problem, use Microsoft Windows Update to
download and install Microsoft Jet 4.0 Service Pack 7 (SP7). To do this, follow
these steps:
- Click Start, point to All
Programs, and then click Windows Update.
- Click Scan for updates.
- On the left pane, click your version of Microsoft
Windows.
- Click the Add button that is next to
Q282010: Recommended Update for Microsoft Jet 4.0 Service Pack 7
(SP7).
- Click Review and install updates, and then
follow the prompts to install the service pack. You may have to restart your
computer after you install the service pack.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This problem was first corrected in OneNote 2003 Service Pack 1.
| Modification Type: | Minor | Last Reviewed: | 1/6/2006 |
|---|
| Keywords: | kbAddIn kbtshoot kbOneNote2003sp1fix kbfix KB827320 kbAudEndUser kbAudITPRO |
|---|
|