If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#51
|
|||
|
|||
Access 2002 vs. 2003
Thank you for posting this: I've been wondering if my
experience was atypical. For my benefit, could you confirm what you are seeing by looking in the registry (use Run, Regedit) at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Excel Originally, my PC showed the Win32 value c:\windows\system32\MSexcl40.dll Later, this was changed to C:\program files\Office11\msaexp30.dll (david) wrote in message oups.com... I have been asked about this at work. I'm a little confused. Some places say that only linking to an excel spreadsheet causes the problem, but elsewhere it says specially linked to a named range in an spreadsheet. My Access version is SP3, Version 10.6501.6626. I created an excel spreadsheet with a named range, linked to it from Access 2002 (Access 2000 file format) and was able to update the information in the named range no problem. What am I missing I wonder? Joel George Nicholson wrote: .....Access cannot write to Excel? Is a gross overstatement. It only involves the updating of spreadsheets that are set up as linked tables within Access, and even then the limitation is one-way. http://support.microsoft.com/kb/904953/ Describes the issues and workarounds. "...Because of legal issues, Microsoft has disabled the functionality in Access 2003 and in Access 2002 that let users change the data in linked tables that point to a range in an Excel workbook. However, when you make changes directly in the Excel workbook, the changes appear in the linked table in Access....." Article includes links to: http://support.microsoft.com/kb/887616/ Office 2003 SP2 (released Sep 27 2005) http://support.microsoft.com/kb/904018/ Access 2002/XP update (dated Oct 18 2005) Anyone with Automatic Updates activated has been living with this for several months. HTH, -- George Nicholson Remove 'Junk' from return address. |
#52
|
|||
|
|||
Access 2002 vs. 2003
From within Access, you changed the linked data and those changes were also
automatically reflected in the Excel file? AFAIK, that, and only that, is what the "update" is supposed to disable. Some places say that only linking to an excel spreadsheet causes the problem, but elsewhere it says specially linked to a named range in an spreadsheet. I assume that the link-to-an-excel file element is all that matters, but I don't know that for a fact. I believe that the "named range" references you've seen (I've seen them too) were in "how-to" workarounds of a specific problem (i.e., "...you used a named range..."), but the possible problems users might run into are not limited to that. HTH, -- George Nicholson Remove 'Junk' from return address. wrote in message oups.com... I have been asked about this at work. I'm a little confused. Some places say that only linking to an excel spreadsheet causes the problem, but elsewhere it says specially linked to a named range in an spreadsheet. My Access version is SP3, Version 10.6501.6626. I created an excel spreadsheet with a named range, linked to it from Access 2002 (Access 2000 file format) and was able to update the information in the named range no problem. What am I missing I wonder? Joel George Nicholson wrote: .....Access cannot write to Excel? Is a gross overstatement. It only involves the updating of spreadsheets that are set up as linked tables within Access, and even then the limitation is one-way. http://support.microsoft.com/kb/904953/ Describes the issues and workarounds. "...Because of legal issues, Microsoft has disabled the functionality in Access 2003 and in Access 2002 that let users change the data in linked tables that point to a range in an Excel workbook. However, when you make changes directly in the Excel workbook, the changes appear in the linked table in Access....." Article includes links to: http://support.microsoft.com/kb/887616/ Office 2003 SP2 (released Sep 27 2005) http://support.microsoft.com/kb/904018/ Access 2002/XP update (dated Oct 18 2005) Anyone with Automatic Updates activated has been living with this for several months. HTH, -- George Nicholson Remove 'Junk' from return address. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Opening an Access 2003 database using Access 2002. | Chantel | General Discussion | 2 | September 1st, 2005 07:15 PM |
Book recommendations, please | Top Spin | New Users | 2 | March 1st, 2005 12:43 AM |
reports created with access 2002 do not work in access 2003? | Jerry Z | Setting Up & Running Reports | 1 | September 24th, 2004 07:27 AM |
Access 2000 DB in Access 2002 | Tony_VBACoder | General Discussion | 2 | July 28th, 2004 01:23 AM |
Access 2002 - 2003 and XP | Joseph Meehan | General Discussion | 1 | June 12th, 2004 07:00 PM |